Calculate Metrics in Insights
You can calculate your own metrics from the metrics already available in your insights using basic arithmetic functions. These ‘calculated metrics’ are available only in the insights where you create them - Analytical Designer does not save these calculated metrics to the Data Catalog.
You can calculate metrics from:
- Metrics, facts and attributes that you add to the Metrics section from the Data Catalog
- Derived metrics created using time-over-time comparison
- Other calculated metrics
You can use the following arithmetic functions:
|A+B||Sum of A and B||##.##|
|A-B||Difference of A and B||##.##|
|A×B||Product of A and B||##.##|
|A÷B||Ratio of A and B||##.##|
|(A-B)÷B||Change from B to A||##.##%|
Create a Calculated Metric
Create an insight with at least two items in the Metrics section.
In the Metrics section, hover your mouse over the plus sign and click Create metric.
In the Outcome is dropdown menu, select the function that you want to use to calculate the new metric.
In the Where section, click Choose Metric and select a metric from the list of available items for both parts of the function (A and B).
The metrics and attributes that you select are highlighted above in the Metrics section.
Analytical Designer adds a new metric to the Metrics section and displays it in the insight.
You run advertising campaigns and you have a set budget for each category of advertising. You would like to know how much money you have left for each different type of advertising.
Your Data Catalog includes the following data:
- The budget for your campaigns (
- The spending on your campaigns so far (
- A list categorizing your advertising channels (
You can use these metrics to calculate the amount of money you have to work with.
Spendto the Metrics section.
Categoryto the Rows section.
- In the Metrics section, click Create Metric and select:
- Difference as the outcome
- Sum of Budget as M1
- Sum of Spend as M2
The following image shows the final insight:
Names of Calculated Metrics
Analytical Designer creates automatic names for calculated metrics. The name consists of the name of the function
and the metrics used. For example,
Difference of Sum of Budget and Sum of spend. For details about changing the name,
see Rename Metrics, Attributes, and Dates in Insights.
Compare Calculated Metrics over Time
You can compare calculated metrics over time as any regular metric. For details, see Use Time-over-Time Comparison in Insights.
Calculated metrics from metrics already derived from time-over-time comparison cannot be compared over time again.
Calculated Metrics vs. Original Metrics
Calculated metrics depend on the metrics that are used to create them. If you delete the metric used to create the calculated metric, the calculated metric and metrics derived from it are also removed. When you drag the metric to the Data Catalog, Analytical Designer highlights all the metrics to be deleted and then displays a message.
If you switch to an insight type that cannot display the metrics used to create the calculated metric, the calculated metric is hidden.
Delete a Calculated Metric
To delete a calculated metric, drag and drop it to the Data Catalog.