Reference lines are a great way to enhance a viz and show how data is performing relative to a set value. However, sometimes it’s advantageous to have control over the value of the reference line. Dynamic references can be created by using a parameter to take a users input. Tableau Zen Master Matt Francis teaches how to create a parameter and use it to control a dynamic reference line.
- [Instructor] Parameters allow to take an input…from a user and use it in our visualization.…A good use of this is a reference line.…It might be the case if you wanna add a value…into our view to compare our data against.…In this example, we're looking at the number…of orders per week in our data set.…We'd like to create a reference line…so we can see which weeks we were above…or below a certain quantity.…First, we need to create our parameter.…First, let's name our parameter.…We're gonna call it Selected Quantity.…
Our data type we're gonna change to an integer.…This is because our quantity is an integer value.…You only have one order, not half an order.…Display format, we'll keep it automatic.…We want a nice sliding range parameter.…So we're gonna set our minimum and maximum values.…In our view, we can see we have ranges from zero…to just over 500.…So let's change our minimum to be zero…and our maximum to be 600.…Step size, we'll keep as one.…We now got our parameter,…which we can add to the view.…
Note that changes parameter…
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.