Designing dashboards in Tableau can be tricky. One problem my students run into is how to space worksheets evenly. It is time consuming to drag the edges of worksheets, making minor tweaks, until they are all the exact same pixel width.
All in Tableau How-Tos
It’s easy to want to cram too much information on a single Tableau dashboard. Whenever I have a scenario where I want to provide additional information to my end user without overcrowding my dashboards, I include an info button.
There will be times when building dashboards when you’ll have multiple worksheets that use the same measure on color. It’s best practice to use color consistently throughout your dashboard, but it can also lead to unforeseen complications. Take the below dashboard as an example.
I shared an example with a class recently about how to use Table Calculations in Tableau and got a request to share this via a write-up. One of the most powerful things about Table Calculations in Tableau is the ability to set a scope and direction.
One of my favorite additions to a dashboard are summary tiles. They’re a great way to quickly communicate a few quick, important data points. In this write-up, I’ll share some of my favorite techniques for building them and making them look crisp. See below for an example of summary tiles I created recently.
I recently got an email from a former student explaining that they were trying to recreate something similar to the image below in Tableau.
The trouble she was running into was recreating the total header called “Planned Cost by Perf”. If you try to use a measure as a discrete header, you end up with the value summed for each partition. Here is an example using Superstore data:
When calculating growth rates from one date period to another, it’s important to compare apples to apples. For instance, when building a graph in Tableau to compare quarterly sunscreen sales in Seattle, I probably wouldn’t want to compare Q3 Sales (July - September) to Q2 Sales (April - June) because there will be more sales in Q3. The product has a cyclical sales cycle. Instead, I would rather compare Q3 Sales of this year to Q3 Sales of last year to more accurately understand growth rates.
Comparing progress against a goal in Tableau is a common use case and I wanted to share a few tips about how I like to do this.