Subset % Function

Subset % calculates what percentage a set of selected attribute values are within an attribute. For example:

A dataset of 100 records has the field ‘Team’.
10 of those records have the ‘Team’ value of ’ Team A’.
The Subset % of ‘Team A’ is 10/100 = 10%.

Modes

Exclude Null
Null values are excluded from the denominator when calculating the percentage.

Include Null Null values are included in the denominator when calculating the percentage.