Sisu provides the ability to set nested filters when defining and iterating on your analysis or drilling down into a fact.
- Configuring a General Performance Analysis
- Configuring a Time Comparison Analysis
- Configuring a Group Comparison Analysis
- Exploring & Drilling Down Into a Fact
Using Nested Filters for Defining Custom Filters
When setting filters or defining groups to compare, you can use a combination of AND and OR filters (referred to as nested filters).
For example, the following nested filters will return shirts that are either red or blue:
Using Nested Filters for Defining Group Comparison
Nested filters can be particularly useful when defining groups to compare in a Group Comparison Analysis.
For example, the following settings will compare red t-shirts to red dress shirts or blouses:
You can filter by:
- a single condition
(color = blue)
- a set of OR conditions
(color = blue OR color = red OR ...)
- a set of AND conditions
(color = blue AND color = red AND ...)
- sets of single or OR conditions joined by ANDs
((color = blue OR color = red) AND (style = shirt) AND ...)
|Within each OR or AND set there is no limit on the number of conditions.|
Each condition can use the following relational operators:
- Equal (=)
- Not equal (≠)
- Less than (<)
- Less than or equal (≤)
- Greater than (>)
- Greater than or equal (≤)
Columns and values used in conditions are populated from the Metric's data source. Sisu users can also create a custom value.
Sisu conditions cannot currently compare against "empty value". If you would like to filter out empty values for a particular column, Sisu recommends defining a special character in your data source.
|Be sure to pay attention to the ORDER in which you set the filters. Creating the filters in the wrong order could have unintended results, or cause an error message if the logic is faulty.|
If when saving a filter or group comparison, Sisu shows an "Invalid filters" error:
If when saving a filter or group comparison, Sisu shows an "Error occurred while saving" error: