Analyzing large amounts of data typically means having to filter the data. A common use case is when you are only interested in the top N results in a dataset. Tableau Zen Master Matt Francis demonstrates how to create a top 10 filter for a dataset and then convert that into a top N filter by creating a parameter and applying that to the filter. Creating a dynamic way to filter any number of values
- [Narrator] Parameters allow us to take a user input to drive what's being shown on view. This can be useful because instead of having to make several different views, we can make one single view at a parameter. Now, a user can change the view depending on their question. Let's look at an example with the World Indicator Data Set. We're gonna look at the countries by GDP. Now, we want to filter this out to only show, say, the top 10 countries. To do that, we're gonna put country on filter and select the top.
And we have to say which field we're gonna use, so we're gonna use the GDP and we want the top 10. We now got a filter in place showing the top 10 countries based on their GDP. And we can publish this and all is well. But what if our user then wants to see the top 20 or top 30? We don't want to have to keep re-publishing exactly the same dashboard and changing every time. A much better approach is to create a parameter, let the user decide what they're gonna see. To do that, we're gonna create a parameter and apply it to the filter. A quick way of doing this is within the filter dialogue itself.
We go to filter, edit filter and in the top section, instead of saying ten, from the drop down, we now create a new parameter. Let's give it a name. And now we can either give a range of values or allow any number. We'll keep it as any number so they can type in whatever number they choose. Do ok, and the parameter is created and displayed on the top right. Now, we can change this to look at, say, the top 25 countries.
Now, we can publish one single sheet with the parameter and allow our user to select how many countries they see.
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.