Aggregation functions group together values from multiple fields to form a single compound value. To choose an aggregation function for a value, use the Field List.
WebDataRocks Pivot Table offers 17 aggregation functions which you can apply to the measures in your report:
Name | Value | Description |
---|---|---|
Sum | "sum" |
Adds all values in the row/column |
Count | "count" |
Counts the number of the rows/columns that contain values |
Distinct Count | "distinctcount" |
Counts the number of the rows/columns that contain unique values |
Average | "average" |
Returns the average (arithmetic mean) of the values in the row/column |
Median | "median" |
Returns the median of the values in the row/column |
Product | "product" |
Multiplies the values in the row/column |
Min | "min" |
Returns the smallest number in the row/column |
Max | "max" |
Returns the largest value in the row/column |
% of Grand Total | "percent" |
Calculates the values distribution across grand totals in the report |
% of Column | "percentofcolumn" |
Calculates the percent distribution across the columns |
% of Row | "percentofrow" |
Calculates the percent distribution across the rows |
Index | "index" |
Calculates the aggregated weighted average to reveal the impact of each value within the context of a dataset |
Difference | "difference" |
Calculates the difference between two values in the row/column |
% Difference | "%difference" |
Calculates the difference between two values in the row/column expressed in percentages |
Population Standard Deviation | "stdevp" |
Calculates population standard deviation of the values in the row/column |
Sample Standard Deviation | "stdevs" |
Calculates sample standard deviation of the values in the row/column |
Running Totals | "runningtotals" |
Calculates running totals (cumulative sum) |