Hi Tableau Community
How about a mapping challenge! We are doing a Hex map that once you select a state, the dashboard switches to the state dB with the respective state. For all states except the Virgin Islands, that works but the VI isn’t in the shape file so we had to get the specific version for VI.
I thought I could swap sheets – so everything but VI using the state sheet and then a sheet just for VI. Problem is, the VI swap is working when selecting the VI Hex map but when I select a state, it shows both VI and the selected state. I’m having trouble getting it to swap correctly. Also there’s a blended data file that will have data for each county or as in the case of VI for the island. That part is working, it’s the swap sheet issue.
This is going to be in a larger dashboard so the file is just the shape files and a small set of data. I'm hoping someone has ideas how to make the VI swap sheet work then I can take that to the larger dB.
Attached is a packaged workbook – start on the national tab (red) and select any state and you’ll see what’s happening. Then select VI and it works.
Thank you
@Thomas Pierre
I guess you don't need the parameter. So, you can define in the state data base:
Swapper Field:
IF [State Abbr/hex] = "VI" THEN 1
ELSE 2
END
In your VI data source:
Swapper Field:
1
and that's it. Attached you will find the workbook.
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
