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
You can assign a function that performs summary calculations on numeric values in columns, groups, or in the entire report. Perform the following steps to apply a summary function:
- 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:
Function Name 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
You can assign an aggregate function to columns that contain numeric and non-numeric values in your report. Aggregate functions return a single value calculated from the values in a column.
- 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.