Filter Functions
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.
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 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 |
Model View |
|---|---|---|---|
| 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. 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. 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). 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). 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. 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. 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. 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. 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 |