Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to setup a chart for employee headcount by month which I have been able to do by using interval match. However, I am not sure how to show only new hires or termed employees for the month in same chart(ideally) or similar chart. For example, in the attached screen shot I would like to see 2 new hires and 1 termed employee for March and the overall headcount is 6. I have also attached a QVW with the example data. Thanks for the help!!
Add two expressions:
New:
=Count(DISTINCT If(Month= Month(HR_Start_Date),EMP_ID))
Termed:
=Count(DISTINCT If(Month= Month(HR_End_Date),EMP_ID))
Add two expressions:
New:
=Count(DISTINCT If(Month= Month(HR_Start_Date),EMP_ID))
Termed:
=Count(DISTINCT If(Month= Month(HR_End_Date),EMP_ID))
This?
Expression for New Hires: =Sum(If(HR_Start_Date = Date, 1, 0))
Expression for Termed: =Sum(If(HR_End_Date = Date, 1, 0))
Or this kind of a stacked bar chart visual:
Thanks Swuel and SunnT! exactly what I wanted. I like the stacked visual idea too.