derivative() function computes the rate of change per
unit of time between subsequent non-null records.
It assumes rows are ordered by the
The output table schema will be the same as the input table.
Function type: Aggregate
Output data type: Float
derivative( unit: 1s, nonNegative: false, columns: ["_value"], timeSrc: "_time" )
The time duration used when creating the derivative.
Data type: Duration
Indicates if the derivative is allowed to be negative.
When set to
true, if a value is less than the previous value, it is assumed the previous value should have been a zero.
Data type: Boolean
A list of columns on which to compute the derivative.
Data type: Array of strings
The column containing time values.
Data type: String
from(bucket: "telegraf/autogen") |> range(start: -5m) |> derivative(unit: 1s, nonNegative: true)
Related InfluxQL functions and statements:
Bug Reports and Feedback
Thank you for being willing to help test InfluxDB v2.0 alpha! Feedback and bug reports are welcome and encouraged both for InfluxDB and this documentation. Submit feedback using one of the following methods:
- Post in the InfluxData Community
- In the InfluxDB UI, click Feedback in the left navigation bar.