Personally, I think one month definition for leavers may not be wide enough.
I'll go for three or two months. Sometimes, people are busy for some reason.
Maybe you can explore two or three months definition and compare if it's much different than the one month. If not, then I guess my theory is wrong and will have to be happy with one month definition.
You are viewing a single comment's thread from:
I am running a query now to test this idea. Adding months increases the complexity of the query so I will only check from 2021 onwards to limit the scope, but I can make a chart from the data and compare it to the one in the original post.
Original chart:
New Chart:
In the 1 month definition it is between 30 and 40% each month, in the 3 month definition it is between 25% and 33% each month. So the shorter term absenses make up about 1 in 5 to 1 in 4 among 'leavers'.
Thanks, not so unexpected. Interestingly, it sort of smoothen things a little.
Personally, I thought 3 months is a good cut off because our maternity leave here used to be 3 months (it's 4 months now). I think it's possible to have a parameter to default the number of months you want to take (be it 1 or 3) in the SQL query. You can change it later when you think when you want to adjust the definition