Applying an Aggregate Function

You can assign an aggregate function to columns that contain numeric and non-numeric values in your report. Aggregate functions return a single value, (for example, Average, Maximum, Minimum) calculated from the values in a column. For example, the sum of a column results from adding all the values in the column.

1.

Click the down arrow next to a report column that contains numeric values.

2.

Select Aggregation from the menu, then select your aggregation type.

Aggregation Types and Descriptions

Function Name	Description
None	No aggregate function assigned
Average	Calculates the average value in a given column
Count	Counts the items in a column Note:Count does not require a numeric value
Count Distinct	Counts the distinct occurrences of a certain value in a column Note:Count Distinct does not require a numeric value
Max	Identifies the highest or largest value in a column
Min	Identifies the lowest or smallest value in a column
Sum	Calculates a running total sum of the specified column

The values in the column update.

3.

Save the report.

Open topic with navigation