integral() function
The integral()
function computes the area under the curve per unit
of time of subsequent non-null records.
The curve is defined using _time
as the domain and record values as the range.
Function type: Aggregate
Output data type: Float
integral(
unit: 10s,
column: "_value",
timeColumn: "_time",
interpolation: ""
)
Parameters
unit
Time duration used when computing the integral.
Data type: Duration
column
Column on which to operate.
Defaults to "_value"
.
Data type: String
timeColumn
Column that contains time values to use in the operation.
Defaults to "_time"
.
Data type: String
interpolate
Type of interpolation to use.
Defaults to ""
.
Use one of the following interpolation options:
- empty sting for no interpolation
- linear
Data type: String
Examples
Calculate the integral
from(bucket: "example-bucket")
|> range(start: -5m)
|> filter(fn: (r) =>
r._measurement == "cpu" and
r._field == "usage_system"
)
|> integral(unit:10s)
Calculate the integral with linear interpolation
from(bucket: "example-bucket")
|> range(start: -5m)
|> filter(fn: (r) =>
r._measurement == "cpu" and
r._field == "usage_system"
)
|> integral(unit:10s, interpolate: "linear")
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, the following resources are available:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.