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 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,
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".
