KATER__COUNT

Family: Aggregations

Syntax

1
KATER__COUNT(field)

Arguments

Returns

A whole number. The field menu writes @format number(0) beside it.

Usage notes

• It compiles to COUNT(field), so a row whose field is empty is not counted.
• To count every row, count a field that is never empty, such as an ID.

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
  KATER__COUNT(orders.order_id) AS "Orders",
4
  KATER__COUNT(orders.notes) AS "Orders with Notes"
5
FROM kater_dataset.orders AS orders
6
GROUP BY
7
  orders.channel
8
ORDER BY
9
  1

Compiles to

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

1
COUNT(orders.order_id)

See also

• Measures
• Other functions in Aggregations: KATER__SUM, KATER__AVG, KATER__MIN, KATER__MAX, KATER__COUNT_DISTINCT, KATER__COUNT_TRUE, KATER__COUNT_FALSE, KATER__LIST