Tableau typically looks at a dataset that contains fixed values. Parameters in Tableau take input from a user and allows interaction with a viz or dashboard enabling a large amount of control over a viz. Tableau Zen Master Matt Francis demonstrates how combining a parameter and a calculated field creates a powerful way to modify the calculation to do what-if analysis.
- [Narrator] In this example,…we've got Sales per Sub-Category,…but what we'd like to know is what kind of change…would a percentage change in sales equate to?…To do that, we're going to use a parameter…to take user input and drive a calculation.…First, let's make a parameter.…We select Create Parameter,…and we'll call this Percentage Change.…We'll keep the Data type as a Float,…and we're going to change the…display format to be a percentage.…We'll remove the two decimal places…because you don't need that much precision.…
I have a nice slide as my parameter,…so for that I'll need to use a range.…Because percentages work between one being 100%,…we want to set the Minimum and Maximum…to be minus one, and plus one,…that way we can look at the…change of minus 100% to 100%.…We're going to set our Step Size…to be naught point naught five,…this means we'll have a five percent…increment in our slider.…We can now add our parameter to our view.…
Note that moving our parameter…doesn't actually change any values.…This is because we actually haven't done…
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.