Interactive Filter Help

[Ralton Stewart]

Community I need some assistance please.

We have a Dashboard that contains 2 SLA's 

1. Opened Cases

2. Closed Cases

I created an interactive filter (Boolean) made sure that the report has follow interactive filter checked, the issue is when I select All, True or False the numbers stay the same and I cannot work out how do get it to display correctly. The report themselves are accurate and are working as expected.

All i want is to be able to do is be able to toggle between the 2 different SLAs set for E365 versus non-E365

this is what the filter looks like

[AndersBGS · Accepted solution]

Hi @Ralton Stewart ,

According to your description, you're trying to filter the SLA which lives in the table task_sla, but your interactive filter reference the sn_customerservice_case table? As far as I can see, this is not configured correctly. 

The reports "open pcr" and "closed pcr", which table are these reports based on? 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[AndersBGS · Accepted solution]

Hi @Ralton Stewart ,

According to your description, you're trying to filter the SLA which lives in the table task_sla, but your interactive filter reference the sn_customerservice_case table? As far as I can see, this is not configured correctly. 

The reports "open pcr" and "closed pcr", which table are these reports based on? 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Ralton Stewart · Accepted solution]

@AndersBGS the PCR reports are on this table

[AndersBGS]

All right, so the reason the interactive filter doesn't work is, that your interactive filter reference one table but reports are created based on other table. You need to create the interactive filter on the same table as the reports - if not, then it will not work.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Ralton Stewart]

@AnderBGS Thank you