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")

Empty tables

last() drops empty tables.



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


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

Cloud or OSS?

InfluxDB OSS 2.0 now generally available!

InfluxDB OSS 2.0 is now generally available and ready for production use. See the InfluxDB OSS 2.0 release notes.

For information about upgrading to InfluxDB OSS 2.0, see: