December 8, 2020
#TableauTipTuesday: How to Sort a Chart with a Parameter Action
- Build the chart
- Create a parameter
- Create a calculated field to sort the bars, then sort the Region field.
- Create de-highlight calculated field and place it on the Detail shelf
- Create a Parameter Action
- Create a Highlight Action
- Turn on Animations
- How to Reorder a Chart with a Set Action - https://www.vizwiz.com/2020/11/reorder-stacked-bars.html
- Data Set - https://data.world/vizwiz/superstore-20203
December 1, 2020
How to Create an Evenly Distributed Butterfly Chart
A Butterfly Chart is (typically) a bar chart where two sets of data series are displayed side by side. The purpose is to allow you to compare the two data series across a dimension.
Here is an example of a butterfly chart I created for Makeover Monday.
Notice how I have zero at the center and the scales are the same on either side of zero. This helps show how the chart "leans" to one side or the other.
The comparisons would be more difficult to see if the left and right hand sides of the butterfly did not have the same axis scale. In this video, I show you how two examples for creating a butterfly chart.
November 24, 2020
How to Create a Combination Bar Chart & Candlestick Chart
In a recent Makeover Monday #WatchMeViz, I showed how to create a bar chart to compare two measures and then add a candlestick chart as well to show the difference between the two measures. It's actually quite simple; it requires some knowledge of:
- How Measure Names and Measure Values work together
- How to create a combined axis chart
- How to create a dual axis chart
- How to create a Gantt chart
November 23, 2020
#MakeoverMonday: America Needs to Pay Its Bills
Today's Makeover Monday marked my 1,000th viz published to Tableau Public. I must say that I'm pretty proud of myself. This feels like a pretty big milestone in my career. I wonder how many hours I've spent using Tableau in my life.
Thank you for all of your support and encouragement along the way. Tableau wouldn't be anything without the Community.
Let's get to week 47. The visualization comes from Visual Capitalist.
- The bar/line combination charts work well since they are on the same scale. This also makes them easier to distinguish.
- Choosing colors that match the American flag (I'm assuming that was intentional)
- Making 2020 a slightly different shade of red
- Title is clear
- Text callouts add useful context
- Big numbers to show the most recent values
- The 2020 bars are at the quarterly level, but the remaining bars are by year. Is it the end of the year? The start of the year? That could easily lead to confusion. Keep it as a consistent time scale.
- Compare debt to GDP
- Show the debt to GDP ratio
- Show when the debt to GDP ratio exceeded 100%
- Highlight important milestones that led to the largest increases
November 17, 2020
How to Create a Single Column Hierarchy Drill Down Drill Up with Parameter Actions
Twice recently I've used parameter actions to create a single column drill down and drill up to mimic a hierarchy.
November 12, 2020
How I Use Layout Containers (Part 2) - HR Analytics KPI Dashboard
November 10, 2020
How I Use Layout Containers (Part 1) - Social Media KPI Dashboard
#TableauTipTuesday: How to Reorder a Stacked Bar Chart with Set Actions
October 28, 2020
How to Create a Venn Diagram
Venn diagrams (also called Set diagrams or Logic diagrams) use overlapping circles to illustrate the logical relationships between two or more sets of items. They depict how things relate to each other within a particular segment.
For example, how many customers made purchases in the East region, in the West region, and in both regions?
Where the circles overlap, you display text or a value the represents the value associated with the relationship.
I created a Venn diagram for my Visual Vocabulary and while teaching how to create it, I thought of a much simpler way to create them. All of the versions you see online (and the version in the Visual Vocabulary) require you to:
- Create sets
- Evaluate how many things are in each set as an aggregate
- Align the circles according to these values
- Create a calc to display the text for the overlap with a computed set
October 26, 2020
#MakeoverMonday 2020 Week 43 - #WatchMeViz - Apparel Exports to the U.S.
For #MakeoverMonday week 43 we analyzed data about apparel exports to the US during the Coronavirus pandemic. In this session of #WatchMeViz, I showed 28 different ways to visualize time series data (there are way more) before we all settled on a viz that's basically the same as the original and looks nicer.
Subscribe to my YouTube channel here to get all of my latest Tableau Tips and notifications for upcoming live streams.
Show Notes / References:
- Data Set - https://data.world/makeovermonday/2020w43-apparel-exports-to-us
- Tableau Reference Guide (incredible repository of thousands of Tableau tips) by Jeffrey Shaffer - http://www.tableaureferenceguide.com/
- How to Shade Between Two Lines with Polygons by Rody Zakovich - http://www.datatableauandme.com/2017/08/how-to-shade-between-2-lines-in-tableau.html
- Title Capitalization - https://capitalizemytitle.com/


