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

ES Pie/Bar chart for manager to view reportees

saipraveengv
New Contributor III
New Contributor III

HI team,

I am trying to configure the Dashboard for Manager. I wanted to have pie chart displayed with contract end date. This would help them to view the details and take action. 

I have followed the guide with usercontext and i am able to set the ES tile type but this would not better insights for the expiry. 

My Sql Query : 

select
u.manager as USERCONTEXT,
m.username as 'Manager ID',
u.username as 'Reportee ID', u.enddate as 'Enddate',
concat(u.firstname, ' ', u.lastname) as 'Reportee Name', CASE
WHEN DATEDIFF(u.enddate, CURDATE()) <= 7 THEN 'Within 7 Days'
WHEN DATEDIFF(u.enddate, CURDATE()) > 7 AND DATEDIFF(u.enddate, CURDATE()) <= 15 THEN 'Within 15 Days'
WHEN DATEDIFF(u.enddate, CURDATE()) > 15 AND DATEDIFF(u.enddate, CURDATE()) <= 30 THEN 'Within 30 Days'
ELSE 'More than 30 Days Ago'
END AS enddate_interval
from
users u
inner join users m on u.manager = m.userkey
where u.statuskey=1 and u.employeetype='contractor'

Let me know if any one had such requirement and were able to acheive using user context

1 REPLY 1

RakeshMG
Saviynt Employee
Saviynt Employee

Please refer to following forum topic for details on USERCONTEXT : https://forums.saviynt.com/t5/community-knowledge-base/how-to-use-user-context-concept-in-analytics-...


​Regards

Rakesh M Goudar