Docs

v2.0

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 will be the same as the input table.

Function type: Aggregate
Output data type: Float

derivative(
  unit: 1s,
  nonNegative: false,
  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. 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

columns

A list of columns on which to compute the derivative. Defaults to ["_value"].

Data type: Array of strings

timeSrc

The column containing time values. Defaults to "_time".

Data type: String

Examples

from(bucket: "telegraf/autogen")
  |> range(start: -5m)
  |> derivative(unit: 1s, nonNegative: true)

DERIVATIVE()


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 in the InfluxData Community