Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to develop a HR dashboard like
Now the Data that I have is an As on data, i.e. I have a single entry for all employees , which is having Hire Date & Separation Date as part of data. If the employee is still there Separation date is null. I can't figure out how to draw a graph like the above one with the help of As on Data. Thanks in advance.
Regards
Amar
Maybe this?
count(distinct if( year("Hire Date") <= Year
and ( len("Separation Date") < 1 // testing for null
or year("Separation Date") >= Year),Employee))