I have a series of temperature readings taken at 15 minute intervals, but I need to aggregate these to the average over an hour so I can merge them with another data stream.
I've tried splitting the time into its date and time components and then building a pivot table, and it's easy enough to get aggregations by day that way. But how to get it by hour?
Thanks.
Bookmarks