Create Composite Metrics
Concept
Composite metrics are calculated around multiple metrics (atomic metrics, composite metrics) through addition, subtraction, multiplication, and division operations. The calculation relationship between different metrics can be customized according to business needs. For example, Channel A Sales Proportion = Channel A Sales / (Channel A Sales + Channel B Sales) or Channel A Sales / Total Sales.
Operation Steps
-
Select "Metric Center > Metric Topic" in the navigation bar, click the "New Metric" button, and select "Composite Metric".
-
In the "New Composite Metric" dialog, set the basic properties, calculation properties, and management properties of the composite metric.
| Parameter | Description |
|---|---|
| Name | Set the Chinese name of the metric, which cannot be repeated under one topic. |
| English Name | Set the English name of the metric, which cannot be repeated under one topic. |
| Business Properties | Fill in the business caliber and the indicator attributes defined by the administrator. For metric attribute management, see Metric Attribute Management. |
| Calculation Formula | Perform composite calculations based on metrics under the current topic in the editor. Note: Only supports calculations on numeric metrics.  |
| Data Format | Set the display format of the metric result. |
| Applicable Dimensions | Control the dimensions that can be associated with the composite metric. When "Use the common dimensions of metrics in the expression" is checked, the common dimensions of each metric in the calculation formula are automatically taken; when not checked, the applicable dimensions can be manually selected. Default is all selected, and the candidate items are the union of the dimensions of each metric in the calculation formula. After modifying the calculation formula, if it was manually selected before, the system will retain the dimensions that still exist in the new candidate items, and the non-existent dimensions will be removed. |
| Business Caliber | Maintain the business meaning of the metric to facilitate subsequent metric applications. |
| Save Location | Set the save location of the metric. |
| Owner | The interpreter of the business caliber, responsible for the rationality and accuracy of the business caliber. |