Calculate the rate of change

• Rate of change between subsequent values

Use the to calculate the rate of change per unit of time between subsequent non-null values.

By default, derivative() returns only positive derivative values and replaces negative values with null. Cacluated values are returned as floats.

Given the following input:

returns:

To return negative derivative values, set the nonNegative parameter to false,

Given the following input:

The following returns:

Results represent the rate of change per minute between subsequent values and include negative values.

Average rate of change per window of time

returns the average rate of change (as a float) per unit for time intervals defined by every. Negative values are replaced with null.

aggregate.rate() does not support .

Given the following input:

The following returns:

Related articles

• derivative() function

query