elapsed() function

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)

events.duration() function

elapsed