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.

Note: 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.

Note: Numeric 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 Name	Description and Use	Stream View Filter Panel Field Types	Model View Filter Panel Field Types
All	All field data values are retained.	Any	Any
Select	Field data values are filtered using up to 50 selected values, to only retain data that contains the specified selections. Note: Search functions are not case-sensitive.	String, Boolean, and binary values	N/A
Exclude	Field data values are filtered to omit up to 50 values, to only retain data that does NOT contain the specified selections. Note: Search functions are not case-sensitive.	String, Boolean, and binary values	N/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). Note: When filtering, the comparison is case-sensitive.	String and binary values	Non-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). Note: When filtering, the comparison is case-sensitive.	String and binary values	Non-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. Note: The value entered is validated, and then the filter is created only if the value is valid.	Numeric values	Measure values
Field data values are filtered according to the entry in the Value field, to only retain data equal to the specified value. Note: When filtering, the comparison is case-sensitive.	String and binary values	Non-measure values
Does not equal	Field data values are filtered according to the entry in the Value field, to only retain data not equal to the specified amount. Note: The value entered is validated, and then the filter is created only if the value is valid.	Numeric values	Measure values
Field data values are filtered according to the entry in the Value field, to only retain data not equal to the specified value. Note: When filtering, the comparison is case-sensitive.	String and binary values	Non-measure values
Greater than	Field 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 than	Field 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 values	Measure values
Null	Field data values are filtered to only retain data that includes (or excludes) null values (Show only or Exclude selection, respectively).	Any	Non-measure values