I am searching an opportunity to get the amount of something. I have ml/h and want to get the sum of ml over time. Like I have km/h and want the distance after 3 hours of driving.
I tried Integral, but it didn’t work. Then I tried sum and some other possibilities, but they didn’t work neither.
Also please tell us whether the ml/h measurements are being made on a regular
basis (once per second, once per minute, etc), since if they are not, it makes
the calculation significantly more tricky.
this example is in german, but there is a count for emails / day and summerized at the end cumulative.
In your case i would build an avg grouped by timestamp and calculate the cumulative for the avg.
How to implements depends on your database.