Filtering reports on dashboard with 'OR' function (Interactive Filters)

[Mr_ Thornquist]

Hi,

I'm trying to set up a dashboard where we want to list tasks that are assigned to my group, and being able to filter on customers country code and ALSO select different customers. 

Use Case: I want to only show customers that are tagged with country code SE (Sweden) but I also work on a specific customer in DK (Denmark) so I want to list that specific customer in the list as well. 

When I apply two different interactive filters on the dashboard (One for country code and one for customers) it acts as 'AND' and not 'OR'. How can I make it so that it solves the use case? 

[Dr Atul G- LNG · Accepted solution]

Hi @Mr_ Thornquist 

You'll need to write a custom interactive filter and add in the OR logic.  OOTB filters do not support OR.

https://www.servicenow.com/community/platform-analytics-forum/custom-interactive-filter-with-or-cond...