integral() function

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
    <-tables: stream[A],
    ?column: string,
    ?interpolate: string,
    ?timeColumn: string,
    ?unit: duration,
) => stream[B] where A: Record, B: Record
For more information, see Function type signatures.



Unit of time to use to compute the integral.


Column to operate on. Default is _value.


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


Type of interpolation to use. Default is "".

Available interplation types:

  • linear
  • empty string for no interpolation


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


Calculate the integral

    |> integral(unit: 10s)

View example input and output

Calculate the integral with linear interpolation

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

View example input and output

Was this page helpful?

Thank you for your feedback!

Introducing InfluxDB 3.0

The new core of InfluxDB built with Rust and Apache Arrow. Available today in InfluxDB Cloud Dedicated.

Learn more

State of the InfluxDB Cloud Serverless documentation

The new documentation for InfluxDB Cloud Serverless is a work in progress. We are adding new information and content almost daily. Thank you for your patience!

If there is specific information you’re looking for, please submit a documentation issue.