elapsed() function
The elapsed()
function returns the time between subsequent records.
Given an input table, elapsed()
returns the same table without the first record
(as elapsed time is not defined) and an additional column containing the elapsed time.
Function type: Transformation
elapsed(
unit: 1s,
timeColumn: "_time",
columnName: "elapsed"
)
elapsed()
returns an errors if the timeColumn
is not present in the input table.
Parameters
unit
The unit time to returned.
Defaults to 1s
.
Data type: Duration
timeColumn
The column to use to compute the elapsed time.
Defaults to "_time"
.
Data type: String
columnName
The column to store elapsed times.
Defaults to "elapsed"
.
Data type: String
Examples
Calculate the time between points in seconds
from(bucket: "example-bucket")
|> range(start: -5m)
|> elapsed(unit: 1s)
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, the following resources are available:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.