SET_CUSTOM

Family: EVAL and its modifiers

Write it inside EVAL.

Syntax

1
EVAL(measure, SET_CUSTOM(condition))

Arguments

Returns

The measure over the rows that the condition keeps, on each row of the result.

Usage notes

• The condition replaces every part of the context, the grouping included. A row’s region or month no longer applies, unless the condition names it.
• The measure’s own definition still applies.
• It cannot be mixed with another modifier in the same EVAL.

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.sum__quantity) AS "Units",
4
  MEASURE('online_units', EVAL(orders.sum__quantity, SET_CUSTOM(orders.channel IN ('web', 'email')))) AS "Online Units, All Regions"
5
FROM kater_dataset.orders AS orders
6
WHERE
7
  KATER__IS_NOT_NULL(orders.region)
8
GROUP BY
9
  orders.region
10
ORDER BY
11
  1

Online Units is the same on every row: the web and email units of every region. The condition replaced the grouping by region too.

See also

• Change a measure’s context
• Pass through, evaluate or declare
• Other functions in EVAL and its modifiers: EVAL, CLEAR, REMOVE, SET, CURRENT