Tableau UI Tip 4: How to Pass Filters and Parameters Between Workbooks

We’re eventually going to overwrite the date range of the destination workbook on Tableau Public by passing new date parameters from the origin workbook. To start, I’m going to change the date range to 9/1/2017 – 12/31/2017.

The trick to passing filters and parameters between Tableau workbooks involves dashboard actions and modifications to the URL string. To demonstrate this, I’m going to navigate back to my splash page style dashboard and modify the existing URL dashboard action that was set up for the bullet menu mentioned in the introduction of this post. Of course, you can also set up a new URL dashboard action.

The URL for the destination workbook (which in this case is a Tableau Public workbook) looks like this:

https://public.tableau.com/views/SuperSampleSuperstore/SuperDescriptive

To pass the Minimum Date and Maximum Date parameter values to the destination workbook on Tableau Public, I am going to add this code to the end of the current URL:

?Minimum+Date=<Parameters.Minimum Date>&Maximum+Date=<Parameters.Maximum Date>

The syntax is simply [The name of the field you are changing at the destination] = [The parameter you are passing from the origin, preceded by ‘parameters.’.

A few things to note:

– The field from the origin should be surrounded by <> brackets.
– Add an “&” symbol between each new item you are passing.
– The first item should start with a “?”, but if there is already a question mark symbol in the URL string, use an ampersand instead (the question mark should only be used once per URL).
– I added plus signs (“+”) to replace blank spaces in the URL.

The full URL now looks like this:

https://public.tableau.com/views/SuperSampleSuperstore/SuperDescriptive?Minimum+Date=<Parameters.Minimum Date>&Maximum+Date=<Parameters.Maximum Date>

Now if I click the bullet menu, not only does the Super Sample Superstore workbook open in a new window, but it is filtered to the same parameter values as the origin. Note that the date range of 9/1/2017 – 12/31/2017 overwrote the original 9/1/2016 – 3/31/2017 range.

This did work, but there is no data for 12/31/2017 so the range is cut off on the 30^th.

Passing filters works the same way as passing parameters. You can pass an individual dimension member (i.e. dimension filter) along with parameters. For example, perhaps I would like to pass not only a date range between workbooks, but also have the destination filter to a specific region. In this case, I would add a new URL dashboard action to the charts that contain the Region dimension and add this query string to the end of the URL:

?Region=<Region>&Minimum+Date=<Parameters.Minimum Date>&Maximum+Date=<Parameters.Maximum Date>

The dashboard action looks like this:

Now if I click ‘East’ in one of the charts that are broken down by region, not only does the destination workbook open with the date range from the origin, but it also filters to the East region.

This example was used purely for illustration purposes, but you can pass whatever parameters, filters, and/or dimension members you would like between workbooks as long as both workbooks contain the same fields! This works on Tableau Public, Tableau Online, or Tableau Server.

Thanks for reading,
– Ryan