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

# Calculate Attrition in Tableau

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

PFA TWB.

• ###### 1. Re: Calculate Attrition in Tableau

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

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

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

• ###### 3. Re: Calculate Attrition in Tableau

Hi Shaikh,

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

BR,

NB