Calculate average values per minute and max values per minute

[GIS_User01]

Good morning!  

I am trying to create a new data table that pulls the average wind speed for each minute.  My issue is that the data is being captured every few seconds.  I need to figure out a way to export a table that shows the average wind speed for each minute of the data and also a table that shows the maximum wind speed for every minute.  Can anyone help?

Thanks so much in advance!

Best,

Bobby

[JagdeeshN · Accepted solution]

Hi @GIS_User01 ,

Please find attached a sample solution to do this using the text to columns tool. You can also do the same using RegEx.

Do let me know if this helps.

Best,

Jagdeesh

[GIS_User01]

Hi @JagdeeshN ,

I appreciate the help and you have helped me tremendously!  I went ahead and added in the hour as well so that I can rebuild a date/time field to associate with those average and max values.  Do I use a RegEx to get that info concatenated together into a new date/time field?  Can you assist with that as well?

[Jacobarod]

Thank you for providing this! I'm sure this will prove useful in my current class as we're learning about Alteryx.