The CreatorCon Call for Content is officially open! Get started here.

Cannot get Interactive Filter to work on dashboard for cases

Marta G
Mega Guru

Hello All

i am trying to create new custom interactive fields, one to be able to filter by date and one by service.

We are using the CSM module with a parent generic sn_customerservice_case table, and multiple child tables (finance case, HR case created by us and so on). I created a dashboard with a series of reports on such tables, and a request is for the client to be able to quickly filter among all results. 

Unfortunately no out of the box interactive filter exists for the case table, so I have tried creating a new one.

MartaG_0-1760353183427.png

copying the OOTB for Incidents, I also added the below:

MartaG_1-1760353297244.png

 

But it doesn't work. I can add the filter to the dashboard but it doesn't matter what timeframe i select, the case numbers is the same, and it doesn't really adjust any data. 
I have also tried checking both options 

Apply to all tables in hierarchy
Apply to both database views and tables
But without any success
 

Any idea how can i get this to work?

thanks!

0 REPLIES 0