KATER__CALCULATE_PER

Family: Calculate at

Syntax

1
KATER__CALCULATE_PER(measure, function, field [, ...])

Arguments

Returns

A number. The field menu writes the @format of the field it reads beside it, or @format number(2) where that field has none and can have decimals.

Usage notes

• Only combinations with rows count, so a month with no orders is not in the average.
• Its menu name is Per. It compiles to CALCULATE_PER(measure, fields, summarize => function).
• Declare it with MEASURE and a name of its own, as the field menu does, such as MEASURE('per_order_month_avg__count_distinct__order_id', ...).
• The query reads one model with no joins, and has no window in its SELECT.
• Another query cannot read a field made with it. Write it in the query that needs it.

Example

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

1
SELECT
2
  orders.region AS "Region",
3
  EVAL(orders.count_distinct__order_id) AS "Orders",
4
  MEASURE(
5
    'per_order_month_avg__count_distinct__order_id',
6
    KATER__CALCULATE_PER(orders.count_distinct__order_id, 'avg', orders.order_month)
7
  ) AS "Orders per Month" /* @format number(1) */
8
FROM kater_dataset.orders AS orders
9
WHERE
10
  KATER__IS_NOT_NULL(orders.region)
11
GROUP BY
12
  orders.region
13
ORDER BY
14
  1

See also

• Calculation context
• Other functions in Calculate at: KATER__ALWAYS_BY, KATER__IGNORE_GROUPING_BY