These are chat archives for influxdata/influxdb
I'm trying to do this:
I have a measurement that keeps track of transactions that enter and leave a queue. I am using a field with the possible values of 1 and -1. 1 for entering the queue and -1 for leaving. I can use cumulative_sum for calculating how many transactions were in the queue at a given point of time. The problem is I don't want to do this calculation every time I need it, so I want to save "snapshots" of the calculations and then do the next calculations based on the previous snapshot and the new data.
I haven't found a way to do this. I've tried continuous queries but they aren't working the way I need.
Any help would be appreciated.