KATER__ROW_TOTAL

Family: Totals

Syntax

1
KATER__ROW_TOTAL(field, field [, ...])

Arguments

Returns

A number in the unit of the first field. 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

• It compiles to COALESCE(field, 0) + COALESCE(other, 0) + ..., so an empty value adds 0.
• Over measures it is a formula of measures, so the total of the row total is the sum of the totals of its fields.
• Declare it with MEASURE when every field is a measure, as MEASURE('row_total', ...) AS "Total", and with DIMENSION otherwise. A query has one row total.

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
  MEASURE('gift_units', KATER__SUM(CASE WHEN orders.is_gift THEN orders.quantity ELSE 0 END)) AS "Gift Units",
4
  MEASURE('other_units', KATER__SUM(CASE WHEN orders.is_gift THEN 0 ELSE orders.quantity END)) AS "Other Units",
5
  MEASURE('row_total', KATER__ROW_TOTAL(gift_units, other_units)) AS "Total"
6
FROM kater_dataset.orders AS orders
7
GROUP BY
8
  orders.channel
9
ORDER BY
10
  1

Compiles to

The call compiles to the same SQL on DuckDB and on Snowflake.

1
COALESCE(gift_units, 0) + COALESCE(other_units, 0)

See also

• Charts
• Other functions in Totals: KATER__TOTAL