Tableau 2018.3 was officially released today, October 30th. Set Actions is one of the most intriguing features I’ve been waiting for.
From my point of view, it enables a whole new universe of use cases.
Just today I found a way to employ them while working on a cohort analysis.
Here’s a stacked bar chart showing how users are progressing through a sales funnel by their acquisition date:
It’s quite easy to analyze “Closed” leads (the dark violet part of the bars) and the totals. The situation becomes difficult when we try to compare the other stages amongst themselves (“Stage 2”, “Stage 3”, and “Lead”).
One thing we can do is to use percentages instead of the actual values. Comparing people in the “Lead” segment becomes easier, but we lose track of the totals, and we still have difficulties with the middle stages (“Stage 2” and “Stage 3”):
Enter Set Actions
To focus on one category at a time while keeping the others in sight, I implemented an interactive component.
Notice how we can move the bars we’re interested in at the bottom by merely clicking on a particular stage “button”:
Now it’s much easier to compare the different groups since we can quickly place them on a common baseline.
With this new feature, we can change the values within a set by clicking or hovering on certain dashboard elements.
Update: I discovered this article by Steve Wexler where he deals with the stacked bar issue in a similar way using parameters. He also offers some examples where stacked bars work very well. A must read!
Go forward if you want to see how you can do it on your own!
The technical part
The process is quite accessible.
Let’s start with a regular stacked bar chart over a time period:
Part 1: the set
Step 1: We first need to create a set with the categories (stages in our case).
Step 2: Make sure you select the “Use all” option for the set (Tableau will default to these values when the set action is cleared):
Step 3: drag the newly created set to the Detail shelf (placing it on the Color shelf would remove the current dimension from there, and we don’t want that)
Step 4: Change set mark type to Color (this will keep both pills on the Color shelf)
At this point, you’ll notice your colors will get messed up (you can just set them up once again).
Now that we have our set in place, we need some “buttons” to drive our interactivity.
Part 2: the set action controller
Step 1: For the buttons we shall create a new sheet with a horizontal dummy bar chart.
This is how I set them up:
Step 2: Clean them up, drop them onto a dashboard, line everything up and we have our viz:
It’s just missing the cool interactivity. Step 3: add it!
Go to Dashboard > Actions, click on Add Action, next on Change Set Values:
Step 4: Configure the Set Action; here’s how:
At this point the action should become functional:
As you can notice, there are two glitches:
- the highlighted parts are at the top
- the colors for the non-highlighted portions are messed up
No to worry! We should go back to our stacked bar worksheet and do some changes.
Step 1: make sure the set resides above the categorical dimension!
Step 2: Sort the set value so that “In” resides below “Out”.
Right click on set and choose the “Sort” option.
The most reliable option would be to sort the Set alphabetically in descending order. Confirm by looking at the color legend while clicking the controller “buttons”.
Step 3: the highlight colors
We could set the colors for each stage-set combination individually, or we can try a neat trick I learned from Jeff Shaffer.
First, we set the same colors for the “Out” values as we would for the “In” ones:
Secondly, we turn on the highlighter on the legend, and we click on the “In” value:
Next, we open up the legend options and click on “Assign Highlight Colors to Palette”.
We have to repeat this process once after selecting a different stage (category) to make sure that all the colors are right.
And this is it!
It might seem like a lot of work, but aside from the set sorting, the process is pretty straightforward.
Inspiration and final thoughts
I first noticed this kind of interactive stacked bar in a GIF tweeted by Rody Zakovich.
This was another one of those eye-opening situations.
If you want to learn more about what you can do with set actions I recommend Mark Reid’s article, Andy Cotgreave’s tips on proportional highlighting, Chris Love’s viz on Titanic survivors, and Simon Beaumont’s dashboard on Premier League Players origins.
These are probably just scratching the surface. There’s a whole new world to explore, so time to roll up our sleeves and dig in!
I hope you can put some of these ideas to work! If you need any help, let me know!
The main author of the Canonicalized content.
I am highly passionate about data analysis, visualization and whatever helps people reach informed answers faster.
I love what I do, and I am working to improve speed in every aspect of my life.
I find comfort in helping people so if you have a question give me a shout!