Examples: Create Expressions and KPIs
See how expressions and KPIs combine to calculate advanced metrics automatically.
To illustrate the creation of expressions and KPIs, we will look at some examples.
First, we will create two expressions called INCOME and COGS.
We will then create a KPI called GROSS MARGIN % which uses these two expressions to show the gross margin in %.
Finally, we have an example where we create a KPI based on measures.
Section Content
Create KPI based on Expressions
Combine saved expressions with mathematical formulas to calculate advanced business metrics.
Create KPI based on Measure
Learn to combine different measures to calculate custom metrics like average price.
Create expressions: INCOME and COGS
Create logical groups of accounts that can be reused in multiple calculations.