How to Create Dynamic Titles for Tableau Dashboards

Remember the Attribute function? It returns a value if there is only a single value for a result set, otherwise it returns an asterisk.

45-1.png

The logic going on behind the scenes is basically this:

45-2.png

You can use the framework of this logic to build dynamic dashboard titles.

Imagine you have this dashboard:

45-3.png

When you select a state, it takes you to a secondary dashboard that is filtered by that selection.

45-4.png

The functionality works well, but sometimes it is easy to forget what state you are viewing after filtering to the second dashboard because it isn’t noted anywhere. Imagine if the title of the dashboard was “Sales Details for Washington” rather than “State Sales Details”. That would be more powerful.

We can create a calculated field that updates based on whether a state is selected.

45-5.png

We can use that calculated field to create a worksheet that looks like a title.

45-6.png

 We can then use that worksheet in place of the original title and it will be filtered based on the filter passed from the first dashboard.

45-7.png

 

Need help building a dynamic title? Sign up for an office hour now so we can help!