I am trying to solve the issue with the water consumption calculation. I am using influxDB as a data source where I am colecting the water pulses. One pulse means 10 liters of water. It looks like this:
And using the cumulative_sum() I get this cumulated value per time interval:
What I wanna to do is to calculate the hourly consumptions from the cumulation above, for example water consumption from 8:00 to 9:00, 9:00 to 10:00 etc.
Could someone please help me with this if it is possible?