Forum Discussion
unnijoy
Post Prodigy
Post ProdigyPerfomance based on Quartile
I have the attriton Data based on Team Manager and country. I need to find the quartile and based on that we need to see whcih quartile the TM falls under. Fotr this i need a formula that will calcul...
Hi unnijoy ,
You can also use the attached file for Visulaization.
https://drive.google.com/open?id=12XyFQmI9bZpSXy08lgMc8EpVuwQQ42ZG
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
unnijoyPost Prodigy
Post Prodigyhi Anonymous
thanks for the help.
can you please help me to modify the formula in such a way that if i have more country. lets say 100 countries. In that situation how to modify this formula.
I need to find Min and MAX also.
Top Quartile = Attrition % Between MIN and <=25th Quartile
50th Quartile = > 25th Quartile <= 50th Quartile
75th Quartile=>50th Quartile and <=75th Quartile
Bottom = >75th Quartile and <= MAX
Please help me to get the formula to match this.
Thanks again for your help.
You also have to state if you want a relative or absolute calculation.
Best
D
Best
D