EVAL

Family: EVAL and its modifiers

A modifier changes that context for this one value.

Syntax

1
EVAL(measure [, modifier])

Arguments

Returns

The measure’s value for each row.

Usage notes

• Each EVAL takes one kind of modifier. Several SETs apply in order, and each one sees the context the one before it set. Any other mix, such as REMOVE with SET, is refused.
• The measure’s definition still applies under every modifier. The WHERE of the model that declares it, its required filters and its joins stay in force.
• A model that reads this SELECT sees an EVAL column as a dimension. To pass a measure on as a measure, select it as it is, such as orders.sum__quantity.
• An AS alias does not rename an EVAL. Two EVALs of one measure in one SELECT have the same name, and the compile fails. Declare the second one, such as MEASURE('all_units', EVAL(orders.sum__quantity, CLEAR())).
• An EVAL of a dimension is the same dimension. A dimension takes no modifiers.

Example

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

1
SELECT
2
  orders.channel AS "Channel",
3
  EVAL(orders.sum__quantity) AS "Units"
4
FROM kater_dataset.orders AS orders
5
GROUP BY
6
  orders.channel
7
ORDER BY
8
  1

See also

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