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:
| 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) |