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
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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi unnijoy ,

         

        Pbix attached.

         

        https://drive.google.com/open?id=1c_4sDlGxYnUrJ9epuyN4u6qvJyCR97q6

         

        Remove SUM in Visualization view and change it to Don't Summarize to get the correct results. Also, find the single card as required.

         

        Regards,

        Harsh Nathani

         

        Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!