7 Replies Latest reply on Nov 6, 2018 2:37 PM by Zhouyi Zhang

# Show Rank1 Rank2 Rank3 in Tooltip

My table is like that;

CITY  -  SHOP - SALES -   MONTH

Here my aim is to make a map and,

to see the :

max sales shop of each city,

2nd rank selling shop of each city,

3rd rank selling shop of each city,

in tooltip in map.

Thanks for helps.

• ###### 1. Re: Show Rank1 Rank2 Rank3 in Tooltip

Is the rank based on month or sum of all months?

Can you provide a sample workbook with dummy data but similar data structure as your real data?

ZZ

• ###### 2. Re: Show Rank1 Rank2 Rank3 in Tooltip

Sum of all months.

But I need the max as (total sales per shop)  (not each sale max)

For ex :

 CITY SHOP SALES MONTH PARIS SHOP A 15 201808 MADRID SHOP A 10 201808 MADRID SHOP A 25 201808 MADRID SHOP B 20 201807 MADRID SHOP B 10 201806 MADRID SHOP B 10 201805 MADRID SHOP B 10 201805 BARCELONA SHOP B 10 201804

Here ın MADRID the max selling shop is SHOP B (with total 50 sales)  not SHOP A with 25 sales

When I go on the MAP, MADRID , I need to see the max 3 ranked cities

• ###### 3. Re: Show Rank1 Rank2 Rank3 in Tooltip

You can take advantage of viz in tooltips.

1. Create the map that displays the cities

2. Create a table that ranks the shops (in my example I used customer)

3. Insert table into tooltip of the map

Let me know if this solves your question.

Cheers,

Sasha

1 of 1 people found this helpful
• ###### 4. Re: Show Rank1 Rank2 Rank3 in Tooltip

Yes I know that thank you.

But I do not prefer it , it slows down the dashboard.

Thanks.

• ###### 5. Re: Show Rank1 Rank2 Rank3 in Tooltip

Please see my sample below use the rank 1 as example with your sample data, in your case, you can change it to "<=3".

once you create the calculation, you can use this as filter and drag it to filter, set up the table calculation as below and choose 'True'

Hope this helps

ZZ

2 of 2 people found this helpful
• ###### 6. Re: Show Rank1 Rank2 Rank3 in Tooltip

I want to use that as tooltip

• ###### 7. Re: Show Rank1 Rank2 Rank3 in Tooltip

It is achievable, could you provide some more data that could help generate top 3 shops?

ZZ