Documentation

min() function

The min() function selects record with the lowest _value from the input table.

Function type: Selector
Output data type: Record

min(column: "_value")

Empty tables

min() drops empty tables.

Parameters

column

The column to use to calculate the minimum 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"
  )
  |> min()

New! 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: