Inactive filter (Date range)

[Stubby]

Hello, ServiceNow community

Got a doubt with respect to a requirement, is there a way to implement an interactive filter to show records in a date range as the list options (Today, Yesterday, Last week,......). This will be applied to 2 reports, one for active records and the other for inactive, in the same tab.  

Had tried a Date interactive filter with 2 filter references, but it didn't work:

• Incident (closed_at)
• Incident (opened_at)

I don't know if a better approach is to create 2 filters, one for open and one for closed, and split the reports into tabs.

Thanks in forwards!!!

[Elijah Aromola]

You could just create your report for the dates, leave out the active flag. Then group by active and they would be able to see the date ranges for each.

[John Skiba]

I'm certainly interested in a solution to this as well.  The need is quite common and many people create an incident report with created and then a dataset report in same report with closed.   A graph by month is quite common with open/closed tickets next to one another.   Users want a date filter so they can simply select "last 3 months" for example.  

The problem is when you target the interactive filter to created (sys_created_on) for example, well naturally the closed report dataset that contains closed ticket counts that weren't created in that month but a previous one will be filtered out.  Thus, the issue.

It would be nice if there was a date filter that simply covered this OR scenario.   Simply, anything in January opened or closed reports on its respective January report.    

Additional separate reports and tabs just add technical debt and less user friendly.