The calculated fields generally used with a string parameter to swap measures are:
WHEN '1'THEN [Topic1]
WHEN '2' THEN [Topic2]
Good example and explanations here:
Another option is:
If [Parameter]= '1' then [dimension] end
if [Topics]= '1' then [Topics 1]
elseif [Topics]= '2' then [Topics 2]
elseif [Topics]= '3' then [Topics 3]
Once that is done you need to bring the calculated field either in the workbook view.
Tableau allows you to filter by dimensions so if you drag the topic dimensions (topic 1, topic 2, etc) on the filter shelf you'll be able to filter by topic.
1 of 1 people found this helpful
You can follow the above post to get the Topics calculation.
Here I've mentioned how to link your URL in the dashboard.
In your dashboard drag a image container put any image. Right click on the image there is a option to set the URL.
You can put your URL there. This will navigate you to that particular site in web.
I hope this may help you.
Thanks for the lead on this. I'm missing one critical piece apparently. I have the calc field and parameter (for a string) but the calc field, when placed in the worksheet view, only returns an All or Null value. There are 12 excel columns (1 for each topic) that I've put in the one parameter. Is this correct? See the screenshots.
Vis link: | Tableau Public
Parameter (NOTE the same topics show up in different events. i.e. Technology is in Topic 8 and Topic 12 for different events). Does this matter? The parameter automatically kicks out duplicates:
Thanks. What I'm going for is how make sure the URL action in the dash actually displays the links. My links just happen to be to individual photos.
I did some more work, thinking maybe it needed an https VS http modifier, but no luck. You can see the URL does display in the tableau app, but not online.
Web view (no photo):
Hey Stephane - So I did some more work and found that I can get the CASE calc field to work, but I'm not able to set it up by what I want, which is Topic Subject (i.e. STEM, Technology, etc.). I can set it up by Topic Header (i.e. Topic1, Topic2, etc), but that's not what I'm looking for. This is due to how the data is structured in excel. See screenshot. Any advice on how to set up the calculated field correctly for all the topics?
Updated vis with both parameters (Topic Header parameter works, Topic Subject parameter does not): | Tableau Public