Hi EDT, Question, extending from the example workflow using values for multiple hours presented for a single day as a row where a daily average could be calculated by calculating between column values:

Is there an easy way to calculate the daily average (and potentially using a similar workflow find the other basic descriptive statistics if possible with the same workflow) for a single day from datetime sensor data similar to that shown below? In this case there is not a set of entries for a single day but a time series.

Here is an example dataset showing 30 minute even-timed example sensor data (random sensor data values):

Here is the data embedded in a otherwise blank .TRANSFORM file to act as an upload container to the forum: sampleData.transform (8.2 KB)

What I am looking to do is output

**general descriptive statistics (avg., count,. sum, max, min, median, mode, stdev., etc.)**for each day, with the average being the most important of all of these figures. Also, I don’t see median and mode as options in Pivot, are these available via another approach?