On this page
Kater SQL Functions Aggregations
Aggregations
An aggregation combines the values of many rows into one value for each group.
The Aggregations menu writes them. A measure is declared with one, such as MEASURE('sum__amount', KATER__SUM(orders.amount)). See Measures.
| Function | What it does |
|---|---|
KATER__SUM | The total of the field’s values. |
KATER__AVG | The average of the field’s values. |
KATER__MIN | The smallest value of the field. |
KATER__MAX | The largest value of the field. |
KATER__COUNT | How many rows have a value in the field. |
KATER__COUNT_DISTINCT | How many different values the field has. |
KATER__COUNT_TRUE | How many rows have TRUE in the field. |
KATER__COUNT_FALSE | How many rows have FALSE in the field. |
KATER__LIST | The field’s different values, as one text value. |