Aggregate Values and Totals

Prior to this enhancement, aggregation operators were only available in custom reporting. Further, only group aggregation was available.

With this enhancement, aggregation operators are now available in Reporting 2.0. Aggregation operators enable users to total their reports by applying average, minimum, maximum, or sum to selected columns. Reporting 2.0 delivers aggregations for the entire data set and outputs the result in the last line of the report. Group aggregation is still available in Reporting 2.0 simply by summarizing the report.

Aggregate values display for each segment of a summarized report. In addition, a grand summary appears as the last row in a summarized report.

Migration Note: Migration of custom reports that have aggregation operations in their reports is not yet available.

Aggregate Operators

The type of operator that is available for a field depends on the field type. All fields can be aggregated by count and count unique, but only numeric fields can be aggregated by sum, average, minimum, and maximum.

Aggregate values are displayed for each segment of a summarized report.

To access aggregation operators, click the icon to the right of the field name in the Table Columns section. This opens the column properties panel. The available operators appear in the Apply Aggregation section:

Aggregation Operators for Numeric Data Types

The following aggregation operators are available for numeric data types:

Aggregation Operators for All Data Types

The following aggregation operators are available for all data types: