On this page
Kater SQL Functions Calculate at
Calculate at
These functions work a measure out at a grouping that is not the query's own, such as each region's total on each channel's row.
The Calculate at menu writes them as By, Per and Across. See Calculation context.
| Function | What it does |
|---|---|
KATER__ALWAYS_BY | The measure worked out by exactly the fields you name, whatever the query groups by. |
KATER__CALCULATE_PER | The measure worked out by the query’s grouping and the fields you name, then combined back to the query’s grouping. |
KATER__IGNORE_GROUPING_BY | The measure worked out without the grouping and the filters of the fields you name. |