Skip to main content
Pentaho Documentation

Filter functions

The filters used in data inspection and their applicability are described in this section.

Filtering is an important tool for exploration and analysis 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.

NoteFilters 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.
NoteNumeric filters in Model View are only available when other field types are present in the drop zones, and these filters are cleared when non-numeric fields are removed from the drop zones or when the visualization changes.
Filter NameDescription and Use

Stream View

Filter Panel Field Types

Model View

Filter Panel Field Types

AllAll field data values are retained.AnyAny
Select

Field data values are filtered using up to 50 selected values, to only retain data that contains the specified selections.

NoteSearch functions are not case-sensitive.
String, boolean, and binary valuesN/A
Exclude

Field data values are filtered to omit up to 50 values, to only retain data that does NOT contain the specified selections.

NoteSearch functions are not case-sensitive.
String, boolean, and binary valuesN/A
Contains

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

NoteWhen filtering, the comparison is case-sensitive.
String and binary valuesNon-measure values
Does not contain

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

NoteWhen filtering, the comparison is case-sensitive.
String and binary valuesNon-measure values
Equals

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

NoteThe value entered is validated, and then the filter is created only if the value is valid.
Numeric valuesMeasure values

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

NoteWhen filtering, the comparison is case-sensitive.
String and binary valuesNon-measure values
Does not equal

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

NoteThe value entered is validated, and then the filter is created only if the value is valid.
Numeric valuesMeasure values

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

NoteWhen filtering, the comparison is case-sensitive.
String and binary valuesNon-measure values
Greater thanField data values 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 thanField data values 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 valuesMeasure values
NullField data values are filtered to only retain data that includes (or excludes) null values (Show only or Exclude selection, respectively). AnyNon-measure values

See also