large datasets
3 TopicsAverage 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.Solved747Views1like4CommentsGetting sorted data in bunches
Hi All We have a dataset with 100K rows in the following format: And we have a flow that is getting data from this dataset Due to the fact that flow cannot get all 100k rows in one go we are getting it in bunches of 25k rows, using autoincremented index, after that we are creating csv file from it - no problems so far. But we also need to be able to sort data by any of those columns and then get data in 25k rows bunches, so we cannot use min-max ID for that any more 😞 , and becouse we have a lots of columns, creating index for each column is not an option, all to be done dynamically. So the question is - how can we get 100k rows of dynamicaly sorted data from dataset into flow ? ThanksSolved1.2KViews0likes7Comments