spread() function

The spread() function outputs the difference between the minimum and maximum values in a specified column. Only uint, int, and float column types can be used. The type of the output column depends on the type of input column:

  • For columns with type uint or int, the output is an int
  • For columns with type float, the output is a float.

Function type: Aggregate
Output data type: Integer or Float (inherited from input column type)

spread(column: "_value")

Parameters

column

The column on which to operate. Defaults to "_value".

Data type: String

Examples

from(bucket: "telegraf/autogen")
  |> range(start: -5m)
  |> filter(fn: (r) =>
    r._measurement == "cpu" and
    r._field == "usage_system"
  )
  |> spread()

SPREAD()

This documentation is open source. See a typo? Please, open an issue.


Need help getting up and running? Get Support