RATIO

Family: Calculation context

Syntax

1
RATIO(value, baseline)

Arguments

Returns

The value divided by the baseline. It is null when the baseline is zero or a value is missing.

Usage notes

• A measure in either argument is worked out at the row’s grouping, so the ratio is the ratio of the row’s totals.

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
  EVAL(orders.count_distinct__order_id) AS "Orders",
5
  RATIO(orders.sum__quantity, orders.count_distinct__order_id) AS "Units per Order"
6
FROM kater_dataset.orders AS orders
7
GROUP BY
8
  orders.channel
9
ORDER BY
10
  1

See also

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