For a pair of consecutive numbers x1, x2 in the input column, calculates the difference between x2 and x1 expressed as a percentage of x1, i.e. 100 * (x2 - x1) / x1.

fill_nan
string
default: "forward"

Method to fill missing values (NaNs). When forward, uses last valid observation to fill a gap. When backwards, uses next valid observation instead.

Values must be one of the following:

  • forward
  • backward
fill_nan_max
[integer, null]

Maximum number of consecutive NaNs to fill before stopping.

Values must be in the following range:

1 ≤ fill_nan_max < inf
as_proportion
boolean

Whether to express result as proportion instead of percentage.

ascending
boolean
default: "true"

Whether to sort ascending instead of descending using the sort column before calculating the change.

Was this page helpful?