Documentation menu

Aggregation functions

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:

NameValueDescription
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 a running total (cumulative sum)