TheLivingBubba
03-06-2025Cloud Apps
Advanced Filtering to use AND & OR on a single field
I'm attempting to assist a colleague who has been asked to perform multiple filters on a single text field. While it is simple to use the text filters to create a single 'Starts With' & 'Ends Wit...
- 03-06-2025
Sisense does not allow directly mixing both "AND" and "OR" logic directly in the filter editor GUI for a single level filter.
The Filter Relationship Editor may be helpful for creating this type of filter, which is documented here.
These links articles threads can be helpful, and discuss this usage - Link 1, Link 2, Link 3, Link 4.
While the exact request does not include this, it is also worth noting that the filters can include negative conditionals, such as "Does not start with".
