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

Hi unnijoy ,

 

Can you confirm if you are looking at the category values based on the Quaritle25,Quartile50, Quartile75  of that specific country.

 

Regards,

Harsh Nathani

 

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.

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

      Hi Anonymous 

       

      thanks for the file. In the file you had shared,you set cards for each quartile based on country(one set of card for Australia and the other for Brazil). can you tell me how to fix it to a single set of card.

       

      So than when i select a country we will have only one set of card which will change based on the country that we select.

       

      Please share the PBX file so that it will be a great 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