Re: [influxdb] Possible to take derivative of time?

2016-09-30 Thread William Cork
Exactly what I needed. For future reference, this worked great: > SELECT DERIVATIVE(ELAPSED(value),1u) FROM BPM WHERE pvName = 'BR1:BPM2:ADC0:clip' AND time > '2016-09-12T18:03:27.012265443Z' and time < '2016-09-12T18:08:04.808883428Z' GROUP BY time(1u) name: BPM - time derivative 2016-0

Re: [influxdb] Possible to take derivative of time?

2016-09-29 Thread Sean Beckett
In InfluxDB, only fields can be passed to functions. The timestamp is a special column and cannot be referenced outside the WHERE clause. Perhaps ELAPSED() is what you need? On Thu, Sep 29, 2016 at 6:15 PM, William Cork

[influxdb] Possible to take derivative of time?

2016-09-29 Thread William Cork
My attempts to call DERIVATIVE on the time column have failed miserably. > SELECT DERIVATIVE(time, 1s) FROM BPM WHERE pvName = 'BR1:BPM2:wfr:TBT:armed' GROUP BY pvName LIMIT 50 ERR: error parsing query: at least 1 non-time field must be queried > SELECT pvName,DERIVATIVE(time, 1s) FROM BPM WHERE