Advanced Filtering to use AND & OR on a single field

Question

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'ANDENDS WITH '03'}OR{STARTS WITH 'A'ANDENDS WITH 'B'}I'm sure that it can be done through the Advanced filter Editor, but all my efforts have c...

Jeremy Friedel · Accepted Answer

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". &nbsp...