Cascading interactive filter to pick a manager then a person

[smithro]

Looking to add a dashboard filter where a manager is selected, and then the users in their org structure.  I basically want to filter a list of incidents where either the manager resolved the issue or if someone in their organization resolved it.

If anyone has created such a cascading filter, some screen shots of the set-up would be very appreciated.

Regards

[Thomas_Davis · Accepted solution]

Hello, 

Here is a ServiceNow Doc that shows the creation process of a Cascading Filter. In the doc, it is showing from Manger to Group, but no reason why the same logic wouldn't for Manager to Users.

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

Here is an Office Hours that discusses Cascading Filters in great depth:

https://community.servicenow.com/community?id=community_blog&sys_id=3db1e070dbac4c185129a851ca961903

[Adam Stout]

How do you determine the resolved by (and the management chain)?  The interactive filter can only do what a normal filter can do.  I'm not exactly sure how I would build this filter in the first place (hard coding a specific user as a test).