We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Manager Direct Reports on Dashboard

sab2
Regular Contributor
Regular Contributor

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!

2 REPLIES 2

Ishan
Saviynt Employee
Saviynt Employee

In the Context field, have you selected User as the value?

Screenshot 2023-02-28 at 11.03.52 AM.png

Ishan Kamat
Technical Architect, Professional Services
SaviyntLogo.png

sab2
Regular Contributor
Regular Contributor

Hi,

Yes, we have context field set to user.