3 Replies Latest reply on Aug 17, 2018 6:32 AM by Naveen B

    Calculate Attrition in Tableau

    Shaikh Imran

      Hello Tableau Team,

       

      I need one help to Calculate Attrition in tableau.I want opening head count/new joining/resignation and closing head count in same month and this data is live data so i want attrition details live.

      I have data such as Joining Date/Resignation date so please suggest how we can calculate this in tableau.

       

      Aug'18 opening head count -  20

      New joining in same month - 4

      Resignation in same month - 6

      Closing Head Count - 22

       

      PFA TWB.

        • 1. Re: Calculate Attrition in Tableau
          Naveen B

          Hi Shaikh,

           

          There is an issue with the twbx file i am unable to open

           

          but check the below image

           

          Aug'18 opening head count -  20

          New joining in same month - 4

          Resignation in same month - 6

          Closing Head Count - 22

           

          Average number of employees = (20+(20-6+4))/2 = 38/2=17.5  ( tableau Calculation : sum(Aug'18 Headcount)+(sum(Aug'18 Headcount)+sum(new Joining)-sum(resignation))/2

          Attrition rate = 6/17.5*100=34.28% (Tableau Calculation SUM(Resignations)/Average*100

          Hope this calculation helps could you please attach the workbook if it didn't help if it helps then mark this answer as helpful or correct so that it will be helpful to others

           

          BR,

          NB

          • 2. Re: Calculate Attrition in Tableau
            Shaikh Imran

            Hello NB,

             

            Attrition rate calculation i now and i want to calculate below 4 filed in tableau using any formula,twbx attached for your reference and please help me to calculate this 4 filed using formula in tableau.

             

            Aug'18 opening head count -  20

            New joining in same month - 4

            Resignation in same month - 6

            Closing Head Count - 22

            • 3. Re: Calculate Attrition in Tableau
              Naveen B

              Hi Shaikh,

               

              Could you please attach the workbook i am unable to previous attached workbook its throwing error

               

              BR,

              NB