Question
Filter target dashboard values for a field matching a substring passed with parameter from source dashboard thorough a URL action
Last Modified Date: 08 Jul 2022
Environment
- Tableau Desktop
Answer
Target Workbook:1) Create a view with the field to filter and all other fields
2) Publish the view to Tableau Server/Online
3) Copy the URL It should look like: https://server.example.com/t/SiteName/views/WorkbookName/TargetDashboardName
Source Workbook:
1) Create a string parameter like below:
2) Create a calculated field like filter button with the following formula:
'Filter Relevant Values'
3) Create another calculated field called Filter calc with the following formula:
CONTAINS([Part id],[Part id substring])
4) Drag the Filter calc calculated field to Filter shelf and select True
5) Drag the field to be passed as a parameter, Part Id in this example to Text on Marks Card
6) Click on Color in Marks card and select white to hide the marks
7) Drag sheet to dashboard and Go to Dashboard -> Action -> Add action -> Go to URL
8) Configure the URL like below:
https://server.example.com/t/SiteName/views/WorkbookName/TargetDashboardName?:linktarget=_blank&Part id=<Part id>
Now when you enter 23 in parameter and click on the filter button, it should filter all the records with part id where 23 is a substring
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials