pct_change(data: number, *sort: column, {
    "param": value,
    ...
}) -> (output: number)

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.

pct_change(data: number, *sort: column, {
    "param": value,
    ...
}) -> (output: number)
​
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?

Suggest edits