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.