Calculate average values per minute and max values per minute

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

CreatingAvereageMinuteValue.yxmd

Date Time

Accepted answers

JagdeeshN

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

CreatingAvereageMinuteValue.yxmd

All comments

JagdeeshN

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

CreatingAvereageMinuteValue.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703