Skip to main content
Pentaho Documentation

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:

  1. Click the down arrow next to a report column containing numeric values.
  2. 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)

     

  3. 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.

  1. Click the down arrow next to a report column that contains numeric values.
  2. 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

     

  3. Save the report.