Interactive filter not working on reports

[Anirudh29]

Hi All

Use Case : There is a Custom table where i store the integration data, and there is a field called "l3 service".
I have a dashboard where i show the reports for SLAs running for l3 services on my custom table. There are many l3 services, hence there is an interactive filter on the dashboard for the l3 services field. But the interactive filter is not working on the sla reports as the table is task_sla. 

For example, the for 1 service there is a resolution SLA running and for another service there is no SLA, if select the service which has no SLA, the report is still showing only the SLAs for the other which is existing. 
Need a workaround for this. 

Thanks,
Anirudh
#itsm #dashboards #reports #developer #servicenow

[Brian Lancaster]

Can you share screenshot of how you reports are configured? How your interactive filter is configured? How the I3 Service is related to the SLAs or the record the SLA is on? We need more information especially when using a custom table.

[Anirudh29]

Hi Brian, thanks for your reply. 

I'm attaching two screenshots, one is the filter on how the report is configured on the SLA table and another one is the L3 service interactive filter on the report.
Let me know if you need any further details.

[Brian Lancaster]

Maybe you should try using the SLA table for the task type instead of the task_sla table. I think it is having problem using the source in the report. So create a report for each task type. So if the SLA is on the incident table you would use incident_sla table for the report.