These are chat archives for influxdata/influxdb

5th
Jan 2017
Miguel Castilla
@miguelcp646
Jan 05 2017 23:05

Hi,

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.