Brian Vancil trained as a physicist, then taught high school science before burning out, and serendipitously ended up in a job that used Tableau for social good. They pivoted to a data science career and now work for the University of Kansas in Analytics, Institutional Research, & Effectiveness as a data scientist.
We present how to use Tableau URL actions to (1) pre-fill forms with data fields or (2) deep link into other systems to informate (i.e. automate connections to other sources of information) your data workflows. The presentation will focus on basic Tableau functionality but push you to stretch how you use Tableau to interact with your information technology environment.
Presentation given to the Higher Education Tableau User Group on 2023-10-17.
- Sadly bare Tableau Public
- Mastodon/Fediverse
- informate was coined by Shoshana Zuboff
- Eric Parker. URL Actions: Use Tableau Like a True App — OneNumber
Although the method can be used for any system that uses GET
-style URLs, we profile a few different options in case studies.
Example: Providing feedback on dashboards.
You may view the dashboard, which links to the survey
We have set up the dashboard to prefill responses using https://docs.google.com/forms/d/e/1FAIpQLSdm28hTNGWKTXT5vk1Wmk3c_BuDvsmnShylr6FLGGx0vaQdyw/viewform?usp=pp_url&entry.1727620612=
username&entry.838417280=
full+name&entry.908520332=
A
Note that Tableau Public prevents dashboards from using the USERNAME()
function.
- Trevor Fox. "Dynamically Pre-fill Google Forms with URL Parameters • Trevor Fox."
- Udara Alwis. "Let’s auto fill Google Forms with URL parameters… | ÇøŋfuzëÐ SøurcëÇødë".
Example: Notifications of bad data.
You can see the dashboard, which links to the survey.
We have set up the dashboard to prefil responses using https://kusurvey.ca1.qualtrics.com/jfe/form/SV_a5W6XAleJJG8Mey?user=
username&name=
Full+Name&id=
id
- Angel Tazzer. "Passing URL parameters to a Qualtrics Survey - YouTube".
- Qualtrics. "Passing information via query strings".
Example: Editing erroneous data.
Detail
: /manage/lookup/record?id=
personUUID
Query landing page
: /manage/query/query?id=
queryUUID
Query
: /manage/query/call?id=
queryUUID
Query output
: /manage/query/run?id=
queryUUID&run=
runUUID
Report
: /manage/report/render?id=
reportUUID&
parameter1Id=
parameter1Value&
...
Report Part
: /manage/report/part?part=
partUUID`
- Free Online GUID Generator
- Slate Knowledge Base. "Parameters in reports".
- Slate Knowledge Base. "Prepopulating or prefilling forms using query string parameters".
quarto render presentation/2023-10-17_bvancil_hetug_tableau-url-actions.qmd
quarto publish gh-pages presentation/2023-10-17_bvancil_hetug_tableau-url-actions.qmd --no-render --no-prompt