last() function

The last() function selects the last non-null record from an input table.

Function type: Selector
Output data type: Record

last(column: "_value")

Parameters

column

Column used to verify the existence of a value. If this column is null in the last record, last() returns the previous record with a non-null value. Default is "_value".

Data type: String

Examples

from(bucket:"example-bucket")
  |> range(start:-1h)
  |> filter(fn: (r) =>
    r._measurement == "cpu" and
    r._field == "usage_system"
  )
  |> last()