Grouping DateTime Data by hour and Averaging Value

[SamThomas]

Hi 

I would like to take this 15 minute data and average it out to 1 hourly data for each site. 

Please see attached sample data. The real data spans 5 years and has a total of 6 sites. 

Thank you. 

[Christina_H · Accepted solution]

Try using DateTimeTrim([DateTime],"hour")

[SamThomas]

Thank you. I would like the data to be grouped based on the day and hour and the 15 minute Value to be averaged over that hour grouping. Is that possible?

[Christina_H · Accepted solution]

The above trims the date time to the hour.  Just add a summarize tool after it, group by the new date time column and average the values.

[SamThomas]

Great, thank you so much.