VALUE_FOR

Family: Calculation context

The rows shown do not change.

Syntax

1
VALUE_FOR(measure, SET(dimension = value) [, more context changes])

Arguments

Returns

The measure for that value, on each row of the result.

Usage notes

• The value in SET must be a constant. To compare each row with the row before, use EVAL with CURRENT.
• The other dimensions of the row stay. In the example, each region’s row shows that region’s web units.

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('web_units', VALUE_FOR(orders.sum__quantity, SET(orders.channel = 'web'))) AS "Web Units"
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

See also

• Change a measure’s context
• Other functions in Calculation context: TOTAL, SHARE_OF_TOTAL, CALCULATE_ACROSS, CALCULATE_BY, CALCULATE_PER, RATIO, RUNNING_TOTAL, MOVING_AVERAGE, CUMULATIVE_SHARE, BY, ACROSS, IGNORE_FILTERS