large dataset problem
1 Topic
Average value based on multiply samples per second, Average by minute
Hello All, I have a large data set, that comes from a tank level sensor. The sensor samples that tank level between 5 and 6 times a second. The tank hold 1500gals, and the min and max level is reocorded in gal. I'm looking to get see trends in tank level across mutly days, weeks, and months. Hoever there is far to much data to be useful. I'm trying to average the tank level across a minute intervals. my first few attempted to average the level value with an anverageX functions and various filters failed. I think I will need to create a new table with a date, time and level coulmns, but am unsure how to generate the required reduced data set. sample data.xlsx in a public one drive. All insights and help into soliving my probelm would be greatly appriated.Solved746Views1like4Comments