Aggregate Values and Totals

Aggregation operators are available from the Column Header Properties panel, which is accessed by clicking the icon to the right of the field name in the Table Columns section. 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.

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

Note: Group aggregation is available by summarizing the report. See Summarize Report.

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: