and more in a single search tool across platforms. Read the announcement here. |
02/28/2023 10:52 AM
Hi,
We are looking to create a dashboard that shows the logged in manager their direct reports. I followed step by step the similar forums post linked here: Solved: Reportee details in dashboard - Saviynt Forums - 7408 . However we could not get it to work correctly on our end.
The analytic details: we used analytic type: SQL V2 analytic, we used Context: User, our query is: select u.userkey as USERCONTEXT,u.firstname as 'FirstName', u.lastname as 'LAST NAME', manager, u.customproperty13 as 'Value' from users u where u.customproperty13 is null;
On our dashboard we have dashboard query: {"analyticsConfig":"1334","fieldToGroup":"userkey"}
We also tried {"analyticsConfig":"1334","fieldToGroup":"username"}
{"analyticsConfig":"1334","fieldToGroup":"loggedinusername"}
we have dashboard type as 'ES Tile'
The issue we are running into is, the dashboard is not filtering for the manager. It will either show as 0 users or it will list all users who meet the criteria in the analytic. Whereas we just want the manager to only see their direct reports missing cp13.
Is there a step or configuration we are missing? We are on version 2021.
Thank you!
02/28/2023 11:05 AM
02/28/2023 11:06 AM
Hi,
Yes, we have context field set to user.