The Insights platform offers several dynamic filtering capabilities, including allowing Analysts to accurately refine their data by applying advanced filter expressions on numeric fields. These expressions support a range of operators and logical combinations, enabling users to create highly targeted filters.
Proceed as follows to leverage these advanced numeric filtering capabilities in an Insights Explore.
Step 1: Understand Number Filter Expressions
Filters on numbers support both natural language expressions and relational operators. Insights supports the OR operator to express multiple filter ranges. The AND operator can be used to express numeric ranges with relational operators to specify a range.
- Natural language expressions - e.g., "3 to 10" represents a range from 3 to 10, inclusive.
- Relational operators - e.g., ">20" represents values greater than 20.
- Logical operators - "OR" (e.g., "3 to 10" OR "30 to 100") and "AND" (e.g., ">=3" AND "<=10") can be used to combine multiple filter expressions.
Step 2: Review Number Filters
The table below provides examples of common numerical filter expressions used within an Insights Explore.
Example
|
Description
|
| 5 | is exactly 5 |
NOT 5
<>5
!=5 | is any value but exactly 5 |
| 1, 3, 5, 7 | is one of the values 1, 3, 5, or 7, exactly |
| NOT 66, 99, 4 | is not one of the values 66, 99, or 4, exactly |
| 1, NOT 2 | is neither 1 nor 2 |
| 1, NOT 2, >100 | is neither 1, nor 2, nor greater than 100 |
| 5, NOT 6, NOT 7 | is 5, is not 6 or 7 |
5.5 to 10
>=5.5 AND <=10 | is 5.5 or greater but also 10 or less |
NOT 3 to 80.44
<3 OR >80.44 | is less than 3 or greater than 80.44 |
1 to
>=1 | is 1 or greater |
to 10
<=10 | is 10 or less |
| >10 AND <=20 OR 90 | is greater than 10 and less than or equal to 20, or is 90 exactly |
| >=50 AND <=100 OR >=500 AND <=1000 | is between 50 and 100, inclusive, or between 500 and 1000, inclusive |
What else do you need help with?
Not what you're looking for? Navigate to Understanding Advanced Filter Expressions for Insights
