How to create an interactive filter on multiple target columns in the same target table?

[Kshitija1]

Hi all,

I am trying to create an interactive filter on Incident table with multiple column. Basically I am trying to create an interactive filter for daily, weekly, monthly resolved and closed incidents. 

for eg, I am trying to replicate this condition into interactive filter - Resolved Date on last week OR Closed Date on last week. 

I tried creating something like this- but its returning data for only Resolved date and not for Closed date.

[knight202]

The video below may help:

https://youtu.be/OirwryvgCrM

[Adam Stout]

Interactive filters are AND'd not OR'd.  If you wanted to do this, you would need a custom interactive filter.

Are you really looking for OR or do you just need closed, but if closed isn't there use resolved?  If that works, then you can add a function field in the reports (using the coalesce function) and this should work without anything custom. 

There are have been a few Performance Analytics Academies on these topics you may want to look through. https://community.servicenow.com/community?id=community_article&sys_id=f2db3382db8220d06621d9d968961...

[Kshitija1]

Hi Adam,

Thanks for the reply. I have 3 different reports :

daily : which is pulling incidents data for Resolved On 'yesterday' OR Closed On 'yesterday'

Weekly: Resolved On 'Last week' OR Closed On 'last week'

Monthly: Resolved On 'monthly' OR Closed On 'monthly'

So, instead of having 3 different reports, I want to have a singly report and a date interactive filter that will pull data from Incident table's resolved and closed columns with above OR condition.

Do I need to create custom interactive filter for this?

can I create 2 date interactive filters, 1 for resolved date and other for closed date, and then create the 3rd one and call those 2 inside with OR conditions?