Hoping someone could assist with this issue.
Within a dashboard landing page, I want to show the average resolution time per assigned to (which I have) but then I want to have a filter that allows one to select multiple managers so when a manager is selected, it shows all of the users that report to the specific manager and their average resolution time.
I am using a dashboard landing page within a workspace and I have a filter that shows a list of managers and a data visualization (pivot table)
Here is what I have so far:
Indicators
Average resolution time of cases: formula indicator with 2 contributing indicators (see below)
Number of resolved cases: Automated indicator that contains the total # of cases in the Resolved state
Summed duration of resolved cases: Automated indicator that contains the total duration of a case between New and Resolved states
Breakdowns
AssignedTo: Users from the sys_user_has_role table that has the sn_esm_agent role
Assigned To.Manager: Users from the sys_user_has_role table that have the sn_customerservice_manager
Filter (within the dashboard landing page workspace)
Manager: Data from the User [sys_user] table where Active = true
Currently, if I select a manager in the filter, the data visualization shows No data available because the manager is not assigned to any of the cases.
Thanks!
