on 2023 Sep 08 10:25 AM
Hello Experts,
We have a requirement to calculate the attrition rate, can you please help me that how we will calculate Attrition rate in story reports.
Thanks,
Arpit
Request clarification before answering.
Hi,
You'll need to create a couple of calculations.
Calculation 1 = if Termination Date is between (the period you want the attrition to be based on) - This forms the No. Of Employee That Left During the Period
Calculation 2 = COUNT of: All 'Active Employees as of the START of the period above
Calculation 3 = COUNT of All 'Active Employees as of the END of the period above
Calculation 4 = The answer to (Calc 2 + Calc 3 above) divided by 2 - this forms the Average Number of Employee of Period
Then you just do the below: as a calculation in the story
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.