A great use of parameters is to use them to swap out an entire sheet on a dashboard for another. This allows the user to select what type of viz they want to see at any time. Tableau Zen Master Matt Francis demonstrates how to create a parameter and use it to create a sheet selection, enabling the swapping out of an entire sheet, such as swapping a bar chart for a map.
- [Instructor] Parameters will take a user input…and change the look and feel of our dashboard.…In this example, we have three sheets in our dashboard.…A map, a heat map, and a line chart.…However, it looks a little bit cramped…and we could probably do a better job of making…it look more attractive.…One way of doing this is to use a parameter to…select which sheet we want to view.…To do that, we're gonna create a parameter.…Let's go to the map sheet.…We select, Create Parameter.…We call this,…Selected Sheet.…
We change it to be a String.…We're gonna list all the sheets that we're interested in.…These are called Map, Heat, and Line.…It's important that these names exactly match the…names of our sheets.…We can click, OK.…We have our selected parameter, we can edit to the sheet.…We now need to create a calculated field based off…the value of this parameter.…We do Create, Calculated Field.…And we'll just call this Sheet.…
We're just gonna take the value of the parameter,…so you don't need to change any more of this calculation.…
The training starts with one of the most important features in Tableau: the difference between the green and blue pills (discrete and continuous data) and how this affects every single action Tableau performs. Then find out how to add new maps and create more effective dashboards that maximize screen real estate. Discover how actions can link together sheets and provide greater levels of interactivity and performance, and how formatting can make an ordinary dashboard demand attention. Plus, get some bonus tips on performing date and time calculations in Tableau. This course deep-dives into the practical, applicable, and essential skills that anyone doing data visualization and analytics in a professional setting needs to have.
- Green vs. blue pills
- Using filters, colors, and dates
- Connecting to data
- Extracting data
- Cleaning and prepping data
- Pivoting data
- Merging and joining data
- Highlighting data
- Using the Analytics pane
- Creating new maps
- Creating calculations based on parameters
- Designing dashboards
Skill Level Intermediate
Q. Thise course was updated 04/21/2017. What changed?
A. Videos were added to cover features in Tableau 10.2.
1. Green and Blue Pills
2. Connect and Extract Data
3. Transform Data
5. Map Your Data
7. Dashboard Design
8. Useful Calculations
9. Tableau 10.2 Updates
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.