Tableau Tips That Continue to Save You Time

Donabel Santos
6 min readSep 29, 2023

One of the first videos I posted on YouTube was about “10 Tableau tricks you should know”. That was a few years ago. Fast-forward to 2023, and I’m amazed (and relieved) to see that many of those tips are still handy and time-saving.

However, unless you use Tableau every day, it’s easy to forget these tricks. You might even forget some of Tableau’s cooler features altogether.

A refresher goes a long way. So, here’s a refresher. Let’s dive back into these time-tested tips — plus a few new ones.

If you’re new to Tableau, consider this your quick introduction to some of its nifty features. If you’re a seasoned Tableau pro, this could be your updated primer with updated screenshots and new perspectives.

Some of these tips can save you time — and can also save you headaches! When you’re stressed, and up against a deadline, the last thing you want is to do rounds of trial and error to find what you’re looking for.

#1 The Magic of Shortcuts

Shortcuts can help us speed up our workflow because they can help us avoid unnecessary, or tedious repetitive steps.

Right-click + Drag (or Cmd + Drag)

Opens the “drop field” window, letting you specify how you want to use the field. This is great for aggregating dimensions, or for choosing a different aggregation for measures.

This replaces the need to drag and drop a field, have Tableau generate a display, and then end up changing the field altogether. For example, instead of displaying a dimension, you can count it right away.

Shortcut: Right click drag

Control + Drag (or Cmd + Drag)

Allows you to copy a “pill” that’s already on the canvas. It saves time especially when copying fields with ad-hoc table calculations.

Shortcut: Ctrl + Drag

Double-click on Measures for Text Tables

For text tables, this allows you to add multiple measures to the existing crosstab with Measure Names and Measure Values (aka proper labels to the numbers)

Shortcut: Double click measures

#2 Finding the Missing Side Bar

The side bar in Tableau has changed in appearance, but it will still be stressful if you don’t know how to minimize and maximize it.

The new side bar now comes with > or < which allows you to maximize and minimize it, respectively.

Hiding and showing the side bar

Alternatively, you can go to Window from the top menu, and toggle the “Show Side Bar” option.

#3 Drag Files for Instant Connection

This simplifies connecting to file-based data sources, like csv, txt, Excel files, PDF, JSON etc.

Common headache:

Connecting to an Excel file when the actual file is csv. By default, many machines will use an Excel icon even if the file is csv (comma separated value file) — so it’s easy to mistake one for the other.

Excel and csv file icons can be easily confused with each other

And if we do make that mistake, we may get a stress-inducing error message:

Potential errors when selecting incorrect file types in connection

Easy solution:

Just drag the file onto an open instance of Tableau Desktop, and Tableau will choose the right option.

Drag file to open instance of Tableau

Tip #4: Import Data Source from Workbook

Sometimes you just want to use that same data source from another workbook.

For example, you may already have a workbook that has multiple data sources. You just want to pick one of these for another project.

Import data source from a workbook

Tip #5: Copy and Paste Data

This allows you to quickly import data to and from Tableau. This is useful when you want to quickly check out some data between applications (for example between Tableau and Excel). This can be a massive time-saver, since you don’t have to create a file, save the file, then connect to the file.

Bonus: you can even copy data from the charts/graphs!

Be wary though: this is only for quick checks. If this is data you want to keep on connecting to, you should create a permanent, proper data set.

Copying from Tableau to Excel and copying from web page to Tableau

Tip #6: Summary Stats Card

Also known as Summary Card, this provides a quick look at either the statistical summary of the whole worksheet or of a selection of points.

It includes: sum, average, minimum, maximum, median

It can also show additional statistics: standard deviation, first quartile, third quartile, skewness, excess kurtosis

Summary Card

Tip #7: Describe Worksheet

When we are handed a workbook to maintain or troubleshoot, we may not even know how to start understanding this workbook.

This workbook doesn’t have to be someone else’s — it could be our own that our younger selves created. And we may have already completely forgotten what it is that we created.

The Describe Worksheet feature allows us to somehow reverse engineer what a worksheet has. While this isn’t a complete documentation of everything that happened to your worksheet, it’s a very good start.

Describe Sheet

Bonus: Describe Field

This helps us understand and explore a field even before we drag it to our worksheet.

Describe Field

Note that for measures, we will need to load the domain before we see that field’s range of values.

Tip #8: Where are my extracts?

When you’re working with a .twb file (Tableau Workbook), you will be prompted where you want the extract to be saved.

Extract with twb file

When you’re working with a .twbx file (Tableau Packaged Workbook), the extract gets saved within the workbook

Extract with twbx file

Tip #9: Reshowing Hidden Field Labels

It’s just one of those things that’s easy to forget. I personally don’t hide field labels often, so it’s always a challenge remembering how to unhide them.

Hiding and showing field labels

Tip #10: TWBX are Zipped Files

Want to see what’s inside a Tableau Packaged workbook (.twbx)? Just rename the file extension from “.twbx” to “.zip” and unzip it like you would any other zip file.

What does it contain? The Tableau Workbook (.twb), any extracts (.hyper) or local file data sources, and images.

What’s inside a Tableau Packaged Workbook (twbx) file?

This is the original video if you’re interested:

Let’s connect: sqlbelle.ck.page

--

--

Donabel Santos
Donabel Santos

Written by Donabel Santos

sqlbelle | Data geek & trainer. Tableau, SQL, YouTube. #WomanInTech | blog: sqlbelle.com | tutorials: youtube.com/sqlbelle | let’s connect: sqlbelle.ck.page

No responses yet