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?