Much like Excel or other tools, Knarr has aggregation functions that you can use in KPIs, charts, and tables to roll up data by your dimensional values.
Currently, Knarr supports some basic functions as outlined below, but over time we will add more complex expression and aggregation capabilities, so check back often!
The expression helper will allow you too add our supported functions to your expressions, including:
Charts default to a distribution, or
count(1), so as soon as you add any dimension, you will see a distribution of those dimensional values.
Within a formula, you can combine these aggregation expressions to perform basic functions like adding, subtracting, multiplying, and dividing:
Quick tip: you can expand the expression editor by clicking and dragging it down, just like in Excel or Google Sheets.
Post in our Ideas forum if you have ideas for additional functions that you'd like to use in Knarr.