Tableau Quick Tip: Create a Gap in Tabular Reports

• By Joshua Milligan
• Posted in All, Calculations, Tableau Tip Tuesday, Tips and Tricks
• On July 5, 2016
• 4 Comments.

Ever design a table in Tableau and wish you could insert a gap between columns or rows? Maybe you want to show several values, but set one apart from the others. Something like this:

Or maybe you want to create some space between categories, like this:

Whatever the reason, in some cases, it’s actually quite easy. Assuming that you are using Measure Names / Measure Values to define the rows or columns, all you need is a Measure that gives you the “gap”.
You might think to use a blank string (e.g. “”), but even as a measure (e.g. MIN(“”)), that can’t be added to the Measure Values shelf which only takes numeric values.
You might use NULL, but by itself you can’t add that to Measure Values either. The trick, is to cast NULL as a numeric value. So create a calculated field with the code:

INT(NULL)
That tells Tableau to have a null value, but the type is integer. Now you can add it to Measure Values and get the gap you want:

In this view, the field is named Null Gap, but has been given the alias of a single space so the header is blank (right click the header and select “Edit Alias” or use the drop down field on Measure Names to edit all aliases). Alternately, you could simply have named the field with a single space.

And finally…

• Want to see the workbook in action or download it? It’s here!
• Not so fond of text tables and want to transition your boss / client / yourself to something more visual?  Check this out!

Hope this helps!
-Joshua