Altair® Panopticon

 

PercentofTotal

For each group and for each group member at all levels of the breakdown hierarchy, the percentage share of its value in relation to the total data set value, where the total is calculated as the sum across all rows in the dataset. This aggregate is similar to PercentofParent, with the difference that the denominator or reference is ALWAYS based on the complete dataset:

[single node value] / [sum of all rows in the dataset]

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

Group Sum

Percent of Total

G1

A

20

125

0.16

G1

B

30

125

0.24

G1

C

50

125

0.40

G2

D

1.5

125

0.012

G2

E

1.5

125

0.012

G2

F

2

125

0.016

G3

G

7

125

0.056

G3

H

9

125

0.072

G3

I

4

125

0.032

 

 

Sample 1 Aggregated to Group Level

 

Group (Parent)

 

Group Value

Total Sum

Percent of Total

G1

 

100

125

0.80

G2

 

5

125

0.04

G3

 

20

125

0.16