2 of 2 people found this helpful
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
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.
1 of 1 people found this helpful
If you have Tableau version 2018.X versions, they have added a new feature of achieving what you want using " Pass Through Functions (RAWSQL)"
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:
Hope it helps.
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.
Ah got it.
Guess I'll have to change some layout.
BTW the lookup(min()) is really cool!
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