WebDataRocks End User License Agreement (“Agreement”) has been revised and is effective as of April 18, 2024.
The following modifications have been made:
The modified version of WebDataRocks End User License Agreement is available here.
Downloading, installing, and/or continuing to use WebDataRocks after April 18, 2024, constitutes your acceptance of the terms and conditions of the modified version of WebDataRocks End User License Agreement. If you do not agree to any of these terms and conditions, do not download, install, use, or access (or continue to access) WebDataRocks.
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 a running total (cumulative sum) |