Data Types and Calculation Methods

The below calculation methods apply to the various data types used in a form template and then applied in a data analysis table.

Contents of Article

1. Primary Aggregation Methods

2. Alternative Aggregation Methods

Primary Aggregation Methods

1. 

Min: Minimum from all underlying values.

Max: Maximum from all underlying values.

2. 

Count: A count of the number of values.

Distinct Count: A count of unique values.

3. 

Sum: Total of all underlying values in the field. This is the default aggregation for any number element when added to the Table.

Average: The total of all underlying values divided by the number of values.MedianThe middle number of all underlying values.

Product: The result of multiplying all the underlying values.

Population StDev: The entire data set is used.

Method: The average of the numbers in the pivot table data =>From each number, subtract the average =>Square the calculated difference for each number =>Find the average of the squared difference =>Find the square root of the average => StDev.

Sample StDev: Same process as above but the average is N-1.

Alternative Aggregation Methods

% of Grand Total: Each value is compared to the overall total as a %.

% of Column: Each value is compared to the column total as a %.

% of Row: Each value is compared to the row total as a %.

% of Parent Column Total: Used when columns are nested to return % of parent column.

% of Row Column Total: Used when rows are nested to return % of parent row.

Index: This will show the relative weight of each cell when compared to its row/column total.

Method: This is (value in cell X grand total)/ (row total x column total).

In a more practical sense this is how it would work:

A player has an overall wellness score of 75 (this is the cell value).
The same player has a total wellness score of 1855 for the date range (this is the row total).
The total for all players that day is 365.5 (this is the column total).
The total for all players for the entire date range is 9124 (this is the grand total).

Therefore it would be (75*9124)/(365.5*1855) = 1.009

Difference of Column: This will show the difference between the current value and value above in the column

Difference of Row%: This will show the difference between the current value and value to the left in the row. Mainly used when values are the row labels.

Difference of Column%: Percentage Change from the current value to value above in column.

Difference of Row: Percentage Change from the current value to value to the left in the row. Once again, mainly used when values are the row labels.

Running Totals of Column: Current value plus values preceding it in the column

Running Totals of Row: Current value plus values preceding it in the row