Event duration calculation

[grant1]

Welcome @yolovs to the InfluxDB forum.

Which version of InfluxDB are you using? If using InfluxDB Cloud v3, you can use SQL (if that is what you are comfortable with).

Here are some examples for calculating the elapsed time:

Time since last data point

I’m trying to do a calculation based on the time elapsed since the last data point was recorded, something like now() - latestPoint._time in seconds. I haven’t been able to find anything that allows you to do something like this besides elapsed() which doesn’t seem to be able to do the exact thing I’m looking for. I was able to figure out how to calculate the time difference (see first comment) but I still don’t know how to convert it to seconds.

[InfluxQL] Selecting value and time since last value

Hello, 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.