Hi All,
I am trying to give some graphical way for the below data
SITENAME EMPLOYEE STATUS 1 STATUS 2 STATUS 3
SITE 1 EMP 1 NEW ACTIVE RENEW TODAY
SITE 3 EMP 2 RENEW TODAY ACTIVE RENEW TODAY
SITE 2 EMP1 NEW ACTIVE RENEW TODAY
SITE 3 EMP1 ACTIVE NEW RENEW TODAY
SITE 3 EMP2 ACTIVE NEW ACTIVE
SITE 1 EMP3 RENEW TODAY NEW ACTIVE
SITE 2 EMP 1 RENEW TODAY NEW NEW
SITE 2 EMP 1 RENEW TODAY ACTIVE NEW
I want to do a graph like below
1) For each site, for each employee, how many NEW, how many RENEW TODAY, how many Active.
I tried my level best but not able to plot this. Could someone help me
Regards
Bookmarks