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

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

        Then you could try to do advanced configuration on your filter and add something like this:

        {
    "or": [{
        "last": {
            "count": 1,
            "offset": 7
        }
    }, {
        "last": {
            "count": 1,
            "offset": 14
        }
    }],
    "and": [{
        "last": {
            "count": 1,
            "offset": 7
        }
    }, {
        "last": {
            "count": 1,
            "offset": 14
        }
    }]
}

        This is something that is only applicable within 1 filter. In this case its a date, however you can change it to text or numbers depending on your filter