Filter by service offering specific to tenant

[anusri21]

Hi ,

I am trying to filter by particular state so that all the reports in my dashboard changes dynamically . for example if i add state OHIO . results in all my reports should be specific to OHIO and if I select Texas. results in my report should be specific to Texas. I added cascading filter which is not working. Please look in to attached images for more clarity.

Appreciate your help.

Thanks.

[Tsura Andreeva · Accepted solution]

You could create a report on that table as a pie chart on distinct state, then use that report as your interactive filter, so based on what slice or the pie chart you use (state name) your report below will change

[anusri21]

Thanks for your reply. in the dashboard which i created there are reports on catalog tasks, request items and incidents . the pie chart should be the common interactive filter for all 3 reports. in the report of pie chart which table should i select?

[anusri21]

Created seperate filters for all 3. 

[Tsura Andreeva]

You could create all those reports based on the task table and use the task table for your pie chart report