Home / Tech Tip / Web Intelligence – Ranking Values

Web Intelligence – Ranking Values

The Ranking button, for filtering a dimension based on its corresponding measures, will return the top or bottom ranked results. Consider the 15th ranked result. What if there were 16 values at the bottom that are evenly ranked? In this case, requesting the top 15 results returns 30 values, 16 of which are for 4 orders. 

Consider a pie chart when the ranking for the top 15 values returns these 30:

The messy pie chart would look like this:

If I want to limit the results to just 15 results (returning just one of the 16 values of 4), then I need a number to differentiate those 16.

In this case, I used the Max(). Any unique numbering will do. An ID number might work perfectly.

I created a variable called Orders =ToNumber(+”.”+Max()).

Creating the ranking of the Customer Cities based on the top 15 Orders, returns these results:

The much cleaner pie chart looks like this:

About ckruger

Check Also

Let’s Speak BO Webinar: Design and Development Techniques for Mobilizing SAP Dashboards October 17, 2017

Webinar: Design and Development Techniques for Mobilizing SAP Dashboards

Join us in a fantastic and informative session with expert developer and Dashboards Consultant, Roxanne …

Leave a Reply

Your email address will not be published. Required fields are marked *