How do we create Interactive filter with relationship?

Rex5 · ‎02-27-2020

Lets say i have a Service interactive filter and Service.parent interactive filter in a dashboard, If i select the Service.parent is selected the other interactive filter populates automatically?

Adam Stout · ‎02-27-2020

Interactive filters do not listen to each other. You can use a Cascading Interactive Filter (which is one filter, not two, but may work for your use case).

Here is some more info:

Office Hours from Aug. 14, 2019 when we covered Cascading Interactive Filters - https://community.servicenow.com/community?id=community_blog&sys_id=3db1e070dbac4c185129a851ca961903

Docs: https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/dashboards/t...

View solution in original post

Kasi Ramanathan · ‎02-27-2020

Could you please elaborate the issue you are facing and kindly share the screenshot.

Rex5 · ‎02-27-2020

Lets say i have an interactive filter "Service" for Service based on CMDB_CI_Service table which pulls all the Services. I also have another interactive filter "Service Parent" which pulls all the Services Parent.

Now having both the interactive filters if i select an element in Service Parent only its child services should display in the "Service" Interactive filter

Is this possible?

Kasi Ramanathan · ‎02-27-2020

https://docs.servicenow.com/bundle/kingston-performance-analytics-and-reporting/page/use/performance...

Community Alums · ‎02-27-2020

If you successfully create an interactive filter you will need to select the "Follow interactive filter" button in the reports widget settings found when you hover over it press the cog.

Please mark as helpful or if its resolved the issue mark as correct!