KATER__ALWAYS_BY

Family: Calculate at

Syntax

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

Arguments

Required

Optional

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

• Grouped by a field you name and by others, each row gets the value of its group. So each channel row of a region shows the region’s orders.
• The query’s WHERE filters still apply.
• Its menu name is By. It compiles to CALCULATE_BY(measure, fields, summarize => function).
• Declare it with MEASURE and a name of its own, as the field menu does, such as MEASURE('by_region_sum__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
  orders.channel AS "Channel",
4
  EVAL(orders.count_distinct__order_id) AS "Orders",
5
  MEASURE(
6
    'by_region_sum__count_distinct__order_id',
7
    KATER__ALWAYS_BY(orders.count_distinct__order_id, 'sum', orders.region)
8
  ) AS "Region Orders"
9
FROM kater_dataset.orders AS orders
10
WHERE
11
  KATER__IS_EQUAL_TO(orders.region, 'EMEA')
12
GROUP BY
13
  orders.region,
14
  orders.channel
15
ORDER BY
16
  2

See also

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