Dates are one of the trickiest data types to handle in data visualisation. Tableau treats dates as both discrete or continuous depending on the context in which they are used. Tableau Zen Master Matt Francis explains how the pill colour determines which mode Tableau will use a date field, and demonstrate the important difference between a blue and green date pill.
- [Narrator] Another key difference…between green and blue pills…when it comes to dates is how Tableau handles filtering.…Let's take a look of that in action…by creating a new Worksheet…using our Order Date…on our Columns.…Let's change that to be a continuous Year,…and we're gonna put Sales on our right.…And now we're gonna break this down…to look at monthly sales for all of our data.…And we'd like to Filter this,…and we want to Filter this on the Order Date.…
So, like any other Filter, we just drag it…onto the Filters shelf.…Tableau now gives us a couple of options.…This depends on whether we want to look at discrete,…which is blue dates or continuous,…which is green dates.…Let's look at the discrete ones first.…Tableau lets us filter on Years,…Quarters, Months, Days, etc.…So, if we select Years,…we get a choice of one of four distinct discrete dates…that are in the data set.…For example, let's pick 2014,…and now we're only looking at all the months for 2014.…
If we do that again, but we select Months,…Tableau now aggregates it all together,…
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
Creating Interactive Dashboards in Tableauwith Nate Makdad1h 38m Intermediate
Data Visualization for Data Analystswith Bill Shander1h 31m Beginner
1. Green and Blue Pills
2. Connect and Extract Data
3. Transform Data
5. Map Your Data
7. Dashboard Design
8. Useful Calculations
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
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.