cancel
Showing results for 
Search instead for 
Did you mean: 

Advanced Filtering to use AND & OR on a single field

TheLivingBubba
8 - Cloud Apps
8 - Cloud Apps

Screenshot 2025-03-06 164926.png
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 With'. However, they've been asked to expand the filter to also return data that meets a further 'Starts With' & 'Ends With' as shown below:

{STARTS WITH '01'
AND
ENDS WITH '03'}

OR

{STARTS WITH 'A'
AND
ENDS WITH 'B'}

I'm sure that it can be done through the Advanced filter Editor, but all my efforts have come to nothing. I would deeply appreciate any assistance & direction that can be given.
Thanks in advance,

1 ACCEPTED SOLUTION

JeremyFriedel
Sisense Team Member
Sisense Team Member

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 2Link 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". 


 

View solution in original post

2 REPLIES 2

JeremyFriedel
Sisense Team Member
Sisense Team Member

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 2Link 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". 


 

TheLivingBubba
8 - Cloud Apps
8 - Cloud Apps

I appreciate the response, Jeremy.
Thank you.