Forum Discussion

unnijoy's avatar
unnijoy
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Perfomance 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...
Need Help
unnijoy's avatar
unnijoy
Icon for Post Prodigy rankPost Prodigy
6 years ago

hi Anonymous 

 

yes but in that we need to add MIN (attr%)and MAX(Attr%).

 

So it will be like MIN,Quaritle25,Quartile50, Quartile75,MAX

Your above formula is correct.

But that is filtered to only 2 country. Can you modify that in such a way that it can be used on multiple country. We have arround 50 countries.

And can you please attach the PBX file also. So that it will be helpfull.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    unnijoy ,

     

    Please check the second file which was attached.

     

    Regards

    Harsh Nathani

    • unnijoy's avatar
      unnijoy
      Icon for Post Prodigy rankPost Prodigy
      6 years ago

      hi Anonymous 

       

      i change the format of percentile to %.

      in that if you check after changing, 75th percentile for Australia is coming as 351.0% in your file.

       

      And now you are using Multiple row card. we have to use single. Like below

       


      • unnijoy's avatar
        unnijoy
        Icon for Post Prodigy rankPost Prodigy
        6 years ago

        Anonymous 

         

        Rather than creating calculated column can we create measures for finding MIN,MAX,25th,50th&75th quartile and use based on this measuse can we catogorise Team manager like top,Bottom,50th and 75th Quartile.