3 More Ways to Make Charming Crosstabs in Tableau

Next we’ll set up a sales goal. For the purposes of this example, we’re going to set the sales goal at $10,000 for every region, category, and quarter. My calculated field looks like this:

SUM([Sales])>=10000

Now let’s bring the shapes in. On the Marks card, change the Mark type from Automatic to Circle. Drag and drop the Met Sales Goal calculation onto the Color property of the Marks card. Set the colors according to what you want to highlight. I decided to highlight the quarters where the sales goal was met, so I set True as a bright green and False as a light gray. To round out this viz, I added Sales to the Tooltip and cleaned it up a bit. Here’s my final view:

It’s now readily apparent that all but two regions and categories hit the sales goal in the final quarter of 2020, and the Technology category in the West region hit the goal every quarter. The time to insight is a lot faster than the original crosstab, and can act as a springboard for further analysis.

Add custom shapes to show a status 

My next example comes from an analysis common in the retail or supply chain industries – asking the latest status related to a product. Was it shipped on time, is it in use, is it on the shelf in a store? Where do we need to increase inventory? I created a mock dataset to show the products by department and their stock status for the fictional chain Playfair Grocery. Here’s the crosstab I’m starting with (you can download the Tableau workbook on this page to follow along):

Again, we see that without the use of any preattentive attributes, it’s hard to glean any useful information. 

To start this visual, place Grocery Store on the Columns shelf, and Department and Product on the Rows shelf. Change the Mark type from Automatic to Shape. Drag Product Status onto the Shapes property of the Marks card. 

When it comes to the shapes, I created custom indicators for in stock, low stock, and out of stock (OOS) in Figma, but you can use whatever tools you have available. Here are my custom shapes:

Once your shapes are added to the Shapes folder in your Tableau Repository, you can assign the shapes in your crosstab. It will look something like this:

Our view isn’t quite finished. First, resize the shapes so that they are legible. Next, I have a simple trick that lets you center the shapes in each column. Double click in the Columns shelf and type MIN(0). Hide your header and gridlines, and ta da! You have centered shapes that are the appropriate size. My final view looks like this:

How to Make Indicators with Custom Shape Palettes in Tableau

Use images instead of text headers 

The third and final option is more about adding some pizzazz to your dashboard than utilizing preattentive attributes to improve a crosstab. Instead of using text to head our table’s columns, we’re going to use images/shapes instead. It’s a simple but effective way to add some visual interest, and is applicable across industries and dashboard uses. 

Let’s say we have this simple crosstab with data from the World Indicators dataset. Region is on the Columns shelf and Measure Names is on the Rows shelf. Measure Values are on the Text property of the Marks card. You can use whatever measures you like in your crosstab, but here’s what mine looks like:

To create the image header, simply choose an image for each of the column headers in your table. For mine, I created a new sheet, placed Region on the Columns shelf and the Text property, assigned the appropriate shapes, hid the headers, and removed the row dividers. (Hint: make sure your column headers are in the same order on both sheets.)

To combine your image header with your crosstab, you can either float your sheets on a dashboard, or you can use containers. I chose to use containers. First I added a Vertical container and added my crosstab with the text headers removed.

Next, I added a Horizontal container within the Vertical container. Add the Image Header sheet to the horizontal container, then add a Blank object to the left side of the same container to ensure the images line up with the appropriate column. The entire view should look like this:

And that’s it! Three more ways you can create charming crosstabs (and hopefully sway your stakeholders towards more viz options in the process!). Thanks for reading!

Happy vizzing,
Alyssa