Back to Influxdb

integral() function

content/flux/v0/stdlib/universe/integral.md

latest5.9 KB
Original Source
<!------------------------------------------------------------------------------ IMPORTANT: This page was generated from comments in the Flux source code. Any edits made directly to this page will be overwritten the next time the documentation is generated. To make updates to this documentation, update the function comments above the function definition in the Flux source code: https://github.com/influxdata/flux/blob/master/stdlib/universe/universe.flux#L1101-L1110 Contributing to Flux: https://github.com/influxdata/flux#contributing Fluxdoc syntax: https://github.com/influxdata/flux/blob/master/docs/fluxdoc.md ------------------------------------------------------------------------------->

integral() computes the area under the curve per unit of time of subsequent non-null records.

integral() requires _start and _stop columns that are part of the group key. The curve is defined using _time as the domain and record values as the range.

Function type signature
js
(
    <-tables: stream[A],
    ?column: string,
    ?interpolate: string,
    ?timeColumn: string,
    ?unit: duration,
) => stream[B] where A: Record, B: Record

{{% caption %}} For more information, see Function type signatures. {{% /caption %}}

Parameters

unit

Unit of time to use to compute the integral.

column

Column to operate on. Default is _value.

timeColumn

Column that contains time values to use in the operation. Default is _time.

interpolate

Type of interpolation to use. Default is "".

Available interplation types:

  • linear
  • empty string for no interpolation

tables

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

Examples

Calculate the integral

js
data
    |> integral(unit: 10s)

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

Input data

*_start*_stop_time_value*tag
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:00Z-2t1
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:10Z10t1
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:20Z7t1
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:30Z17t1
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:40Z15t1
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:50Z4t1
*_start*_stop_time_value*tag
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:00Z19t2
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:10Z4t2
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:20Z-3t2
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:30Z19t2
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:40Z13t2
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:50Z1t2

Output data

*_start*_stop*tag_value
2021-01-01T00:00:00Z2021-01-01T00:01:00Zt150
*_start*_stop*tag_value
2021-01-01T00:00:00Z2021-01-01T00:01:00Zt243

{{% /expand %}} {{< /expand-wrapper >}}

Calculate the integral with linear interpolation

js
data
    |> integral(unit: 10s, interpolate: "linear")

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

Input data

*_start*_stop_time_value*tag
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:00Z-2t1
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:10Zt1
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:20Z7t1
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:30Zt1
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:40Zt1
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:50Z4t1
*_start*_stop_time_value*tag
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:00Zt2
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:10Z4t2
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:20Z-3t2
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:30Z19t2
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:40Zt2
2021-01-01T00:00:00Z2021-01-01T00:01:00Z2021-01-01T00:00:50Z1t2

Output data

*_start*_stop*tag_value
2021-01-01T00:00:00Z2021-01-01T00:01:00Zt125
*_start*_stop*tag_value
2021-01-01T00:00:00Z2021-01-01T00:01:00Zt232.5

{{% /expand %}} {{< /expand-wrapper >}}