Skip to main content
Pentaho Documentation

Filter Functions

Filtering is an important tool for exploring and analyzing data when inspecting your data. You can explore your data in the inspection canvas by applying filters and then viewing the results in the visualization. See Use Filters to Explore Your Data for general information about filters. 

Depending upon the viewing mode and specific field type, the following filtering functions are available as detailed in the table below.

Filters on numeric values in Stream View are applied in the aggregated values or in row level values, depending on the drop zone type (if any) of the filtered field.

Numeric filters in Model View are only available when other type of fields are in the drop zones and these filters are cleared when there are non-numeric fields in the drop zones or the visualization changes.

Filter Name Description and Use

Stream View 
Filter Panel Field Types

Model View 
Filter Panel Field Types

All

All field data are retained.

Any Any
Null

Field data are filtered to only retain data that includes (or excludes) null values (‘Show only’ or ‘Exclude’ selection, respectively). 

Any

Non-measure values
Greater than

Field data are filtered according to the threshold entered in the Value field, along with the ‘or equal to’ checkbox, to only retain data greater than (and, if selected, equal to) the specified value.

Numeric values  Measure values
Less than

Field data are filtered according to the threshold entered in the Value field, along with the ‘or equal to’ checkbox, to only retain data less than (and, if selected, equal to) the specified value.

Numeric values Measure values
Equals
 

Field data are filtered according to the entry in the Value field, to only retain data equal to the specified amount.

The value entered is validated, and then the filter is created only if the value is valid. 

Numeric values

Measure values

Field data are filtered according to the entry in the Value field, to only retain data equal to the specified value.

When filtering, the text is case-sensitive. 

String values

Non-measure values
Does not equal
 

Field data are filtered according to the entry in the Value field, to only retain data equal to the specified amount.

The value entered is validated, and then the filter is created only if the value is valid. 

Numeric values

Measure values

Field data are filtered according to the entry in the Value field, to only retain data equal to the specified value.

When filtering, the text is case sensitive. 

String values

Non-measure values
Contains

Field data are filtered according to the entry in the Value field, to only retain data containing the specified numeral(s) and / or letter(s).

When filtering, the text is case sensitive. 

String values

Non-measure values
Does not contain

Field data are filtered according to the entry in the Value field, to only retain data not containing the specified numeral(s) and / or letter(s).

When filtering, the text is case sensitive. 

String values

Non-measure values