-
1. Re: Selected Value (Map, Chart) as text label
Jim DehnerSep 11, 2019 5:54 AM (in response to Dominik M.)
please attach your twbx workbook so we have a base to use to help you
thanks
Jim
-
2. Re: Selected Value (Map, Chart) as text label
Zhouyi ZhangSep 11, 2019 6:00 AM (in response to Dominik M.)
Hi, Dominik
Please find my solution attached.
Below is the result
Below is the step
Add your dimensions into text and edit the text
and then create action filter
A sample workbook based on the superstore data attached for your reference.
Hope this helps
ZZ
-
Book1_v10.2.twbx 1.4 MB
-
-
3. Re: Selected Value (Map, Chart) as text label
Dominik M. Sep 11, 2019 6:37 AM (in response to Zhouyi Zhang)Hi Zhouyi,
thanks for your reply. I have checked your sample workbook and unfortunately, it doesn't work as expected.
When I am in the lowest hierarchy level, everything is okay, but if I de-select everything, it still states Vietnam (which is MAX(Country)), Souteast Asia and Technology (which is MAX(Category) - see picture below
If nothing is selected (or no category is selected), it shouldn't be shown in the hierarchy level at all, e.g.
Nothing selected:
"Japan"
Region selected (Region is a sub-region of Japan in that example, so below in the hierarchy):
"Japan > Region Central"
If a dealer is selected:
"Japan > Region Central > Dealer 1"
I thought I might miss something straightforward, but in case it requires some workarounds, I have attached the workbook in the initial post.
Thanks
Best Regards
-
4. Re: Selected Value (Map, Chart) as text label
Zhouyi ZhangSep 11, 2019 7:32 AM (in response to Dominik M.)
I think you probably need a data strcture reshape rather than data blending, but not sure it is doable for your case?
ZZ
-
5. Re: Selected Value (Map, Chart) as text label
Dominik M. Sep 11, 2019 7:44 AM (in response to Zhouyi Zhang)I think the data structure might be okay, basically (although this is just a demo dashboard with demo data)
But the basic functionality of the dashboard allows for selecting and de-selecting to still make sense, e.g. if you don't select a region, you get the Top 10 Dealers for Japan, whereas if you select a region, you get the Top 10 dealers for the selected region.
The text is just a help for the user to know where he currently is.
I am surprised that this seems so hard to be achieved by Tableau (I thought there might be a "Selected" function I am just missing or so)
BR Dominik
-
6. Re: Selected Value (Map, Chart) as text label
Jim DehnerSep 11, 2019 7:46 AM (in response to Dominik M.)
good morning Dominik
I agree with ZZ
you are blending dataset and blending limits the functionality available in Tableau - filtering across blended datasets is a problem
Jim
-
7. Re: Selected Value (Map, Chart) as text label
Dominik M. Sep 11, 2019 7:58 AM (in response to Jim Dehner)Sorry, I don't get the connex between the dataset and the functionality required.
The example ZZ provided works with the Superstore set and still has the same issue?
If the question can be resolved with the example from ZZ, I am more than happy to clean the datasets until I can reproduce the solution.
So, taking the Superstore example from ZZ:
(1) If nothing is selected, the text should just show some overall hierarchy (can be fixed value in that example, e.g. Asia)
(2) If a country is selected and no category, it should show "Asia > Japan" (or whatever country is selected)
(3) If a category and a country is selected, it should show "Asia > Japan > Furniture" (or whatever country and category is selected)
(4) If a category is selected and no country, it should show "Asia > Furniture" (or whatever category is selected)
Is this possible?
Thanks
BR Dominik