5 Replies Latest reply: May 27, 2015 10:06 PM by sivasankar kanagasabai RSS

    Headcount trend analysis problem

    Jakub Szurogajlo

      Hello!

       

      Hope you can help me with suggesting appropriate method to resolve below problem.

       

      1. I have list of employees, with Hire Date, Leave Date, and other dimensions

      2. I got a requirement to generate below trend table:

       

      2015
      Q1Q2Q3Q4
      JanFebMarAprMayJunJulAugSepOctNovDec
      Headcount
      New joiners
      Exits

       

      I am struggling to find a proper and clean method of joining employee list with master calendar, so that I can easily distinguish joiners leavers and headcount in specific month...

       

      Any ideas?

       

      Edit:

      I am attaching sample application... In there I linked Master calendar with Hire Date.

      This is of course wrong, because I am not able to properly calculate leavers...

       

      I am looking for different approach which will allow me to calculate everything properly

       

      Regards!