KATER__IGNORE_GROUPING_BY

Family: Calculate at

Syntax

1
KATER__IGNORE_GROUPING_BY(measure, 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

• Each row gets the value for every value of those fields. So each channel row of a region shows the region’s orders on all channels.
• It compiles to EVAL(measure, REMOVE(fields)), so the query’s filters on those fields are dropped too.
• Its menu name is Across.
• Declare it with MEASURE and a name of its own, as the field menu does, such as MEASURE('across_channel__count_distinct__order_id', ...).

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
    'across_channel__count_distinct__order_id',
7
    KATER__IGNORE_GROUPING_BY(orders.count_distinct__order_id, orders.channel)
8
  ) AS "Orders on All Channels"
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__ALWAYS_BY, KATER__CALCULATE_PER