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: A Guide to Geographic Charts in Web Intelligence October 31, 2017

Webinar: A Guide to Geographic Charts in Web Intelligence

Join Adam Lange for an informative webinar on geographic visualizations in Web Intelligence 4.2. Attendees …

Leave a Reply

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