|
Percent of Total Reference
This aggregate works like Percent of Total, with the difference that a value from one column is compared to a total data set level sum of values from another column, which is set as the “Reference column”:
[single node value from a column] / [sum of all rows from the reference column in the dataset]
While Percent of Total will always summarize to 100% across the whole data set, this is not the case with Percent Of Weight Total, which can summarize to any number, depending on the differences between the Values and the Reference Values.
The aggregate value is calculated as a ratio between 0 and 1 and will be presented as a percentage value by applying a percent format string in the aggregation settings.
Sample 1
|
Group (Parent) |
Member (Child) |
Value |
Weight value |
Total Sum of Weight value |
Percent of Total Reference |
|
G1 |
A |
10 |
20 |
125 |
0.08 |
|
G1 |
B |
15 |
30 |
125 |
0.12 |
|
G1 |
C |
25 |
50 |
125 |
0.20 |
|
G2 |
D |
1 |
1.5 |
125 |
0.008 |
|
G2 |
E |
3 |
1.5 |
125 |
0.024 |
|
G2 |
F |
2 |
2 |
125 |
0.016 |
|
G3 |
G |
14 |
7 |
125 |
0.112 |
|
G3 |
H |
18 |
9 |
125 |
0.144 |
|
G3 |
I |
8 |
4 |
125 |
0.064 |
Sample 1 Aggregated to Group Level
|
Group (Parent) |
Member (Child) |
Value |
Weight value |
Total Sum of Weight value |
Percent of Total Reference |
|
G1 |
|
50 |
100 |
125 |
0.40 |
|
G2 |
|
6 |
5 |
125 |
0.048 |
|
G3 |
|
40 |
20 |
125 |
0.32 |