KATER__PERCENT_CHANGE

Family: Calendar comparisons

Syntax

1
KATER__PERCENT_CHANGE(current, baseline)

Arguments

Returns

A fraction, such as 0.25 for 25%. The field menu writes @format percent(1) beside it, so it shows as a percentage. NULL where the baseline is 0 or empty.

Usage notes

• It divides by the absolute value of the baseline, so a change from -10 to -5 is +50%.
• It takes any two numbers, not only a calendar comparison.

Example

This Sandbox query reads the sample shop’s orders. The table shows the rows that Kater gave.

1
SELECT
2
  KATER__MONTH(orders.order_date) AS "Order Month",
3
  EVAL(orders.sum__quantity) AS "Units",
4
  CUSTOM_CALCULATION(
5
    'percent_change__sum__quantity',
6
    KATER__PERCENT_CHANGE(EVAL(orders.sum__quantity), KATER__PREVIOUS_PERIOD(orders.sum__quantity, by => KATER__MONTH(orders.order_date)))
7
  ) AS "Change from Month Before" /* @format percent(1) */
8
FROM kater_dataset.orders AS orders
9
WHERE
10
  KATER__IS_BETWEEN(orders.order_date, DATE '2026-05-01', DATE '2026-09-30')
11
GROUP BY
12
  KATER__MONTH(orders.order_date)
13
ORDER BY
14
  1

See also

• Period comparisons
• Other functions in Calendar comparisons: KATER__PREVIOUS_PERIOD, KATER__SAME_PERIOD_LAST_YEAR, KATER__SAME_WEEKDAY_LAST_WEEK, KATER__PERIOD_SHIFT