topic Re: Calculating an attrition rate in App Development

Calculating an attrition rate

tomelmslie — Sat, 16 Nov 2024 21:33:05 GMT

Hi,

I am trying to calculate and visualise an attrition rate which shows me the rate of attrition month-on-month, but have been unable to calculate it correctly.

I have gone about this by creating my own fields of 'Headcount' and 'Leavers' in order to write the expression. What I have so far, which doesn't give me the right results:

RangeSum(Leavers)/RangeAvg(Above(count(HeadCount),0,12))

'RangeAvg(Above(count(HeadCount),0,12))' correctly displays a moving average of headcount, which is what I want, however 'RangeSum(Leavers)' breaks the formula. The attrition formula I am trying to recreate is:

Sum of leavers (April 2017 - March 2018)/Average Headcount (April 2017 - March 2018)

Any ideas?

Thanks

Re: Calculating an attrition rate

sunny_talwar — Wed, 23 Jan 2019 14:01:36 GMT

May be this

RangeSum(Above(Count(Leavers), 0, 12))/
RangeAvg(Above(Count(HeadCount), 0, 12))

Re: Calculating an attrition rate

tomelmslie — Wed, 23 Jan 2019 14:09:23 GMT

I have tried that variation but it didn't work 😞

Re: Calculating an attrition rate

sunny_talwar — Wed, 23 Jan 2019 14:15:56 GMT

Would you be able to share a sample which we can take a look at?