Create advanced filters in Interactive Reports
You can create filters on multiple groups of fields, or on a single group of fields. Filters on multiple groups are called advanced filters. To create an advanced filter, drag the fields into the Filter Panel. You can place items into multiple groups by moving them up or down. You can create a hierarchy by indenting the fields.
Apply a summary function
Procedure
Click the down arrow next to a report column containing numeric values.
Select Summary from the menu, then choose the summary type. These types are described in the following table:
Summary Type Description None No summary function assigned. Average Calculates the average value in a given column. Count Counts the items in a group or report, but does not require a numeric value. Count Distinct Counts the distinct occurrences of a certain value in a column; does not require a numeric value. Maximum Identifies the highest or largest value in a column. Minimum Identifies the lowest or smallest value in a column. Sum Calculates a total sum of the group or report (group level, and running total in the report footer). Save the report.
Apply an aggregate function
Procedure
Click the Down Arrow next to a report column that contains numeric values.
Select Aggregation from the menu, then choose the aggregation type. These types are described in the following table:
Function Name Description None No aggregate function assigned Average Calculates the average value in a given column Count Counts the items in a column; does not require a numeric value Count Distinct Counts the distinct occurrences of a certain value in a column; does not require a numeric value Maximum Identifies the highest or largest value in a column Minimum Identifies the lowest or smallest value in a column Sum Calculates a running total sum of the specified column Save the report.