derivative() function
The derivative()
function computes the rate of change per unit
of time between subsequent non-null records. It assumes rows are ordered by the _time
column. The output table schema is the same as the input table.
*Function type: Transformation
**Output data type:* Float
derivative(
unit: 1s,
nonNegative: true,
columns: ["_value"],
timeSrc: "_time"
)
Parameters
unit
The time duration used when creating the derivative. Defaults to 1s
.
*Data type: Duration*
nonNegative
Indicates if the derivative is allowed to be negative. Default is true
. When true
, if a value is less than the previous value, it is assumed the previous value should have been a zero.
*Data type: Boolean*
columns
The columns to use to compute the derivative. Defaults to ["_value"]
.
*Data type: String*
timeSrc
The column containing time values. Defaults to "_time"
.
*Data type: String*
Output tables
For each input table with n
rows, derivative()
outputs a table with n - 1
rows.
Examples
from(bucket: "example-bucket")
|> range(start: -5m)
|> derivative(unit: 1s, nonNegative: true)