1 of 1 people found this helpful
To accomplish this "filter-then-rank" task in Tableau,
one could make a datasource of a special flavor, namely, a self-join.
The [Row ID] from the "left" table of the join is used for Filter Action.
The fields from the "right" one are used to build the Target view with "the Text".
Your second requirement of filtering a scope (such as by [Date]) is complicated.
Moreover, it can not be done in Tableau version 9 (as far as I could understand).
It could be made real with Cross-Datasource Filters (new in Tableau 10 Beta 1).
Please find the attached workbooks (both v9.0 and v10.Beta1).
Hope it could help a bit.
PS Sometimes it is just fine to simply put "the Text" in a Tooltip :-)
Thanks so much for the reply Yuriy! After a little bit of work, I was successfully able to recreate your v9 test file. Huzzah!
Unfortunately without the filtering scope, I am in a similar position that I was in before, where hardcoding the ranking pre-load was my temporary fix. I am however very interested to check out your v10 file, but am at a loss as to where to access the source the download from. Is joining the Beta program the only way?
Also, you wouldn't have any idea as to when v10 roles out to the general public?
No luck on the link - it's asking me for credentials which I do not have (my forum credentials don't work).
I did sign up via this link here https://www.tableau.com/tableau-10-beta-program
Hopefully it's the same page...
You should receive from Tableau soon
with a login & pass to Beta 10.
if not, drop me a message to
y.fal AT analytikaplus.ru