docs-v2/content/flux/v0.x/stdlib/universe/spread.md

title	description	aliases	menu	weight	flux/v0.x/tags	related	introduced
spread() function	The `spread()` function outputs the difference between the minimum and maximum values in a specified column.	/influxdb/v2.0/reference/flux/functions/transformations/aggregates/spread /influxdb/v2.0/reference/flux/functions/built-in/transformations/aggregates/spread/ /influxdb/v2.0/reference/flux/stdlib/built-in/transformations/aggregates/spread/ /influxdb/cloud/reference/flux/stdlib/built-in/transformations/aggregates/spread/	flux_0_x_ref name parent spread universe	102	aggregates transformations	/{{< latest "influxdb" "v1" >}}/query_language/functions/#spread, InfluxQL – SPREAD() /flux/v0.x/stdlib/experimental/spread	0.7.0

The spread() function outputs the difference between the minimum and maximum values in a specified column. spread() is an aggregate function.

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.

spread(column: "_value")

Parameters

column

The column on which to operate. Default is "_value".

tables

Input data. Default is piped-forward data (<-).

Examples

{{% flux/sample-example-intro %}}

import "sampledata"

sampledata.int()
    |> spread()

{{< expand-wrapper >}} {{% expand "View input and output" %}} {{< flex >}} {{% flex-content %}}

Input data

{{% flux/sample "int" %}}

{{% /flex-content %}} {{% flex-content %}}

Output data

tag	_value
t1	19

tag	_value
t2	22
{{% /flex-content %}}
{{< /flex >}}
{{% /expand %}}
{{< /expand-wrapper >}}