8 Replies Latest reply on Sep 25, 2016 11:17 PM by Andre Kristianto

# Displaying only the Top 1 based on measure

I recently tried to provide a performance analysis for a telecom provider. This one should be very simple but I can't find the login on tableau how to rank the data then display only the top 1...

Here is the case:

Suppose that we have data about the performance of each telecom provider service in several area like below.

From this I want to make a filled map, which color is based on the top operator by measure (Download Speed, Upload Speed, or Latency) on each area. For example if in nevada the fastest download speed belongs to Verizon it will be red on the map, if AT&T it will be blue, and purple if it is T-Mobile. First, I tried to make a table which display the complete data like below :

Next I tried to display only the top operator but I can't find the logic here. Tried to make a set of top 1 based on measure selection but it failed to provide correct result (picture below) :

If we look at the data, the correct result shall be :

California : Verizon

Washington : AT&T

Can someone help me with this, the logic should be quite simple but I can't find it in Tableau since I am quite new here.

Please find the .twbx file attached if you need it.

• ###### 1. Re: Displaying only the Top 1 based on measure

I don't think sets will work for your use case because you're trying to calculate the top Carrier within each region, as apposed to just the top carriers in an overall dataset.

Have you taken a look at these instructions? Finding the Top N Within a Category | Tableau Software

• ###### 2. Re: Displaying only the Top 1 based on measure

Hi Andre,

You can use Rank(Sum([Download_Speed])), the advanced compute settings are at the level of Operator repeating every Area.  Then use that as a filter and set to 1.

Regards,

Ivan

• ###### 3. Re: Displaying only the Top 1 based on measure

Hi Andre,

Find below screen shot.Let me know if it is wrong.

Regards,

krishna.

• ###### 4. Re: Displaying only the Top 1 based on measure

Hi Andre:

The solution i can think about it is to create rank field  on your selected measure and add it to the level of details,  let it compute using operator dimension.

Then add filter on your new field and select 1 which is the top one.

I hope it is clear and can do the trick.

Abdelmoneim

• ###### 5. Re: Displaying only the Top 1 based on measure

Yes, Tom... I have looked into that topic yet I still can't find any idea... But thanks anyway

• ###### 6. Re: Displaying only the Top 1 based on measure

Yes, it is the correct list, Krishna... It should be like that... and recently I found out a solution from my friend pretty much like yours...

Thanks for helping.

Kind Regards,

Andre

• ###### 7. Re: Displaying only the Top 1 based on measure

To all that has replied, thank you very much... I managed to find out the solution based on your advice... To sum how it

's done, it is pretty much like these steps below :

Hope this help if anyone ever encounter the same problem.

Kind Regards,

Andre