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

Related articles

• InfluxQL – MIN()