Skip to main content
Pentaho Documentation

Analyzer Filters

Overview

Filters are used to restrict or limit data in a report, building the report to show only the information you want to view.

Filter Operators

Within each dimension, you can have non-numeric and numeric filters.

Non-Numeric Filters

Non-numeric filters include the following types: 

  • Include
  • Exclude
  • Contains
  • Does Not Contain
  • Before
  • After
  • Between
  • All relative time filters such as 'Current Year' or '3 Years Ago'.

Operator Ids:

  • EQUAL
  • NOT_EQUAL
  • CONTAIN
  • NOT_CONTAIN
  • BEFORE
  • AFTER
  • BETWEEN
  • TIME_AGO
  • TIME_AHEAD
  • TIME_YAGO
  • TIME_RANGE_PREV
  • TIME_RANGE_NEXT

Numeric Filters

Numeric filters include the following types:

  • Top N
  • Greater Than/Less Than filters

Operartor Ids:

  • LESS_THAN
  • GREATER_THAN
  • LESS_THAN_EQUAL
  • GREATER_THAN_EQUAL
  • EQUAL
  • NOT_EQUAL
  • BETWEEN
  • IS_NOT_EMPTY
  • TOP
  • BOTTOM
  • TOP_BOTTOM

Filter Logic

Each dimension is filtered independently and the results are logically AND'd together. 

Non-numeric filters are always applied before numeric filters and the two groups of filters are AND'd together. Within non-numeric filters, the following operators are OR'd together: Include, Contains, Before, After, Between and relative time filters. These filters are then AND'd together with the Exclude and Does Not Contain operators.

Here's a visual representation:

(
  Include OR Contain OR Before OR After OR Between OR Any Time Filter
) AND (
  Exclude AND Not Contain
)

The above filters are then AND'd with any numeric filters:

AND (Top 10 AND Greater Than)

Within a Contain or Not Contain operator, the individual expressions are OR'd together.