Hello, Im trying to do a rolling sum over the last hour of my data points. I want this sum to be calculated on every data point. Even once every second would be ok.
But I searched around and apparently the second option is only possible with Flux, which isnt supported in InfluxDb3?
This solution gives the sum over the last hour, at specified time intervals 1:00-2:00, 2:00-3:00, etc.
It’s not bad, but what I’m looking for is 1:00-2:00, 1:01-2:01, 1:02-2:02, etc… a rolling window of 1 hr computed every minute. Looks like this is possible with Flux.
Even better though, I’d like the last 1hr computed at every data point… ex. 1:00-2:00, 1:03-2:03, 1:04.50-2:04.50, etc.
I’m surprised because I’d think rolling window was a very common query type.