When calculating metrics, you can use the proportion calculation method to quickly obtain the relationship between the current value and the overall value.
If A has an income of 100, B has an income of 200, and C has an income of 150, then the income proportion of B is 44.44% (200/(100+200+150)).
Use case: Calculate the proportion of the current metric value in the overall value. For example, calculate the income proportion of the employee Zhang San among all employees.
Edition support: All editions.
Through this document, you will learn the following:
Total Proportion
Intra-group Proportion
Total Proportion
The total proportion calculates the ratio of the current value to the sum of all values. The following example demonstrates how to use the total proportion:
1. Enter the canvas, add a column chart component, then set the dimension and metric.
2. In the metric field, sequentially select quick calculation > Proportion > Total Proportion
3. In the style panel, set the value display and format the value as a percentage with 2 decimal places.
Intra-group Proportion
The intra-group proportion calculates the ratio of the current value to the sum of all values across all groups. The following example demonstrates how to use the intra-group proportion:
1. Enter the canvas, add a column chart component, then set the dimension, sub-axis, and metric.
2. In the metric field, select quick calculation, Proportion, and then Intra-group Proportion sequentially.
Note: When no group is available, you are unable to select "Intra-group Proportion".
