How to use both Assignment Group and Assigned to as filter for task based reports in Dashboard

[avi14]

Hello Forum! 

I was seeking some advise in using both Assignment Group and Assigned To as filters for reports in PA Dashboard.

The specification I am aiming to achieve are as follows:

Assignment Group: one of my groups (set up a script used in Interactive Filters for this)

Assigned to: Users in above group.

Although the above interactive filters work on task based reports on PA individually, I was finding difficulty in trying to make the two filters interdependent (Selecting Assignment Group should show users of that group in Assigned To, and vice versa).

Any advise regarding achieving this will be highly appreciated ☺️

Regards,

Abhi

[Chetna · Accepted solution]

Hi Avi,

You may try using cascading interactive filters - https://docs.servicenow.com/bundle/paris-performance-analytics-and-reporting/page/use/dashboards/task/create-cascading-filter.html

Thanks.