[InfluxQL] Selecting value and time since last value


Is there a way to select value of each measurement and time since previous measurement in single SELECT statement?

From what I see, difference method is perfect for that, however, following statement:

SELECT "value", elapsed("value", 1s) FROM ...

produces ERR: mixing aggregate and non-aggregate queries is not supportederror.

This is with InfluxDB 1.7.10.

1 Like