Forum Discussion

TheLivingBubba's avatar
TheLivingBubba
Cloud Apps
03-06-2025
Solved

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...
  • JeremyFriedel's avatar
    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 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".