I’ve looked everywhere but cannot find a good solution for this.
Basically I have an influxdb3 time series with data points coming in randomly around every 1 ms. Each data point contains x and y.
I want to visualize the 1hr rolling sum of (x*y). I want an entry in the visualization for each data point.
I tried SELECT sum(x*y) FROM table GROUP BY time(1hr)…
But this only gives 1 entry for each hour. I want 1 entry for each data point.
Ex. At time 4, collect sum(xy) from time 3 to 4.
At time 4.1 collect sum(xy) from time 3.1 to 4.1… etc