Create advanced filters in Interactive Reports

Archived. Content merged into "Advanced topics" under Pentaho Interactive Reports.

This page is archived. Use Advanced topics for the current, consolidated content.

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.

In this topic

• Apply a summary function

• Apply an aggregate function

Apply a summary function

You can assign a function that performs summary calculations on numeric values in columns, groups, or in the entire report.

1. Click the down arrow next to a report column containing numeric values.

2. Select Summary from the menu, then choose the summary type:

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

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:

   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.