-
1. Re: metric rank by country by global
Hideki OGAWA Nov 27, 2018 11:54 PM (in response to Christian Go)2 of 2 people found this helpfulHi,
It requires some steps.
1) Pivot data in data view to make a dimension 'Metric' and a measure 'Value'
2) Create rank calculation using different levels
3) Prepare 'measure filter' to filter the site
1) pivot data
create table *remember to add 'country' in detail mark.
2) Edit rank
Rank country
Do the same for rank global
3) prepare measure filter
*measure filter is to be applied after the table calculation. it is common to filter after rank calculation.
Best regards,
Hideki OGAWA
-
2. Re: metric rank by country by global
Christian Go Nov 28, 2018 12:07 AM (in response to Hideki OGAWA) -
3. Re: metric rank by country by global
Amar Wattamwar Nov 28, 2018 2:41 AM (in response to Christian Go)1 of 1 people found this helpfulIf you have Tableau version 2018.X versions, they have added a new feature of achieving what you want using " Pass Through Functions (RAWSQL)"
Pass-Through Functions (RAWSQL) - Tableau
Also, if you wan to see it in action, follow this questions :
https://community.tableau.com/ideas/4553 -- check Yuri's answer.
Sadly I have 10.5, so I would also implement the above solution. If you are stuck, try getting the ranks from a database system itself or follow this link:
Tableau Tip Tuesday: How to Filter a Dimension and Maintain the Rank
Hope it helps.
-
4. Re: metric rank by country by global
Hideki OGAWA Nov 28, 2018 1:46 AM (in response to Christian Go)Only Excel, text data, pdf and google spread sheet are supported. It is not a version specific now (v9 afterward, I guess).
For other data sources, custom SQL is available though I am not familiar with it.
Tableau Prep should support other data sources as well.
And yes it duplicates other measures if they are not included in the pivot. Dividing by number of variables will be necessary.
-
5. Re: metric rank by country by global
Christian Go Nov 28, 2018 2:46 AM (in response to Hideki OGAWA)Ah got it.
Guess I'll have to change some layout.
BTW the lookup(min()) is really cool!
-
6. Re: metric rank by country by global
Christian Go Nov 28, 2018 2:48 AM (in response to Amar Wattamwar)Sadly I'm on 10.3, also a database or back-end solution would be hard to implement sadly as it's not my control