Current Attrition Percentage of Employees

[sunil-kumar5]

Hi Community,

I want to calculate the current attrition% of employees based on HR data like EE code, joining date and leaving date.

Can anyone please help on this?

Thanks

Sunil Kumar

[sunil-kumar5]

Hi Steven,

Sorry, but I didn't understand the code to use, as you mentioned desired year (I want this dynamic not specif for any year).

[Steven_Haught]

Sorry for any confusion. You can try something like this:

Count(distinct{$<LeaveDate-={}>}EE_Code)
/
Count(distinct EE_Code)

[Steven_Haught]

@sunil-kumar5  Have you tried that at all? From we can add in more criteria in the set analysis to do 90 hires turnover, 6 month turn over, monthly etc.

[sunil-kumar5]

Hi Steven,

I didn't get the notification.

I tried this way and getting 58% attrition rate, I believe this is over all, can you please advise as how can I calculate this basis on current MTD and YTD attrition rate? 

[Steven_Haught]

@sunil-kumar5  You may need to create a couple of fields. A month and year field would be good. I would also create an active Y/N field. Then we can add those to the set analysis to dictate the time frame and specifics of what you are looking for.