Calculated metrics, or roll-up metrics, allow users to define metrics as the sum or the average of other existing metrics.
To create a calculated metric click on ‘Add New’ and start completing the information in the pop-up. Once you get to ‘Calculated Metric’, click on it and a number of new fields will appear.
- Under ‘Algorithm’ – choose between sum, average or custom. For this example let's choose sum.
- Under ‘Add Children’ – choose the metrics you would like to sum up.
Complete the rest of the form and click on ‘Save’. In your dashboard you will now have a calculated metric. You can click on the plus sign to expand. Now you can see which metrics are being added. Click on the calculated metric to visualise the graph.
Custom algorithms enable you to calculate a metric based on other existing metrics and constants using a customisable calculation formula. For example: You want to calculate revenue in dollars based on the existing revenue in euros and the existing dollar to euro exchange rate using the formula: Revenue in dollars = revenue in euros, multiplied by the exchange rate of the dollar vs the euro
To create a custom calculated metric click on ‘Add New’ and start completing the information in the pop-up. Once you get to ‘Calculated metric’, click on it and a number of new fields will appear.
- Select ‘Custom’ in the ‘Algorithm’ field. In the ‘Add Children’ field select the relevant existing metrics which will form part of the calculation.
- In the ‘Custom Algorithm’ field create the calculation formula. To use existing metrics from the ‘Add children’ field simply start typing the metric-ID-number and then click on the suggested metric.
- Please note that the existing metrics appear in brackets and you need to leave a blank after the bracket before inputting the standard operators. You can use parentheses as part of the formula.
- If required you can also use the if-condition, but when using the if-condition, you have to use the ternary condition operator, which is a little different from what we know from Excel. Please find an example here.
Complete the rest of the form and click on ‘Save’. In your dashboard you will now have a calculated metric. Click on the calculated metric to visualise the graph.