Find below information about the « Finance – Controlling» example in our demo solution.
Here is a glimpse on the data:
You can download the source: Gsheet
In DataMa Compare
This example made for financial assessment is different from other examples because the metric relation is not representing a conversion funnel but a business equation.
We are comparing amount of margin, in that case the margin is the product of :
Margin = Number of Items x (Revenue / Items) x (Margin / Revenue)
This would split the different effect of your business performance, the volume of Items sold, the revenue made with these items sold and at the end the margin earned. This equation could be much more complicated (integrating for example the number of distribution points selling the product, …)
To better understand Metric Relation read our article.