1 2 Previous Next 16 Replies Latest reply on Oct 18, 2016 5:56 AM by Jason Bouligny

    Turnover Rate (Hiring Date and Terms Date)

    Jean Francois Carton

      Hello,

       

      I am doing some turover rates in Tableau, but I am kind of stuck right now..

       

      Can you help me?

       

      I have that:

       

      Emp ID     Emp Name     Employee Status     Hired Date     Terms Date

      0512          Bob               Active                    02/04/13         Blank

      4789          Marie            Terminated              01/07/13        03/27/13

      7893          Jeff                Active                    04/20/13         Blank

      3789          Britanny        Terminated              03/15/13         04/27/13

       

      I would like to have the count for each month of 2013 of the number of Hired and Terminated:

       

                                    Jan     Feb     March     April

      H                             1         1          1          1

      T                              0         0          1          1

      Total Active EE         1          2          2          2

       

      But I am not sure because how to do it because I can't really use the Term or Hire Date as a Ref.

       

      Thank you!

        1 2 Previous Next