Forum Discussion

soporteparaptx's avatar
soporteparaptx
Cloud Apps
07-19-2023

Combine AND and OR in a filter

Hi  We need to perform a filter based on dimension values, according to AND and OR logic like (field starts with 1 OR field starts with 2) AND field does not contain 4 Is there a way to perform...
dashboards & reporting
  • soporteparaptx's avatar
    soporteparaptx
    Cloud Apps
    07-19-2023

    Hi HamzaJ 

    I've seen that, but I'm not clear about how to make it available. Do you know how to enable this feature? It's just on dashboard level also, so it impacts all dashboard, not just a widget, do it?

    Thanks!

    • HamzaJ's avatar
      HamzaJ
      Data Integration
      07-19-2023

      I think it is enabled by default. You can check this by going to a dashboard and click on the three dots ,next to the plus-icon to add a filter, and selecting Filter Relationship.

      If it is not there , you can enable it by going to Admin > System Management > Configuration > Base configuration > Filters and enable filter relationship

      • soporteparaptx's avatar
        soporteparaptx
        Cloud Apps
        07-20-2023

        Hi HamzaJ 

        Thanks for the info, sure, it was not enabled. But, unfortunately, I think that is not going to solve the issue. We need to perform AND and OR combination inside a filter of a field, not between filters related to different fields.

        Thanks