How to build skyscrapers in tableau

So, you are thinking of making a visual to show the distribution of the various line items to the total within the category as well as overall categories

In our (beloved) superstore example, let’s say you want to see how one Sub-category is doing compared to others. In addition, you would like show often an order (or a customer) is providing profit for that sub category, consider a skyscraper graph

Here’s how to build one in 6 steps

Take “Sales” (or relevant metric) to Row

step-1
Step 1

 

Take “Sub-category” (or the relevant dimension) to Columns

step-2
Step 2

 

Take “Customer Name” (or the secondary dimension) to Detail

step-3
Step 3

 

Add the metric (sales in this case) also to Size

step-4
Step 4

 

Create a combined field for Primary and Secondary dimension and add it to detail

step-5a
Step 5a) create a combined field
step-5b
Step 5b) It will look like this

 

Add this field to the detail and sort it by your metric, change the Mark to be “Bars” instead of Automatic

step-5
Step 5) Adding the field to viz

 

Do a bit of formatting and you are done 🙂

Now, for bonus points, you can also add a beacon to your skyscraper using the WINDOW_SUM(SUM([Sales])) as another metric and making it a dual axis

And, you can make it look like this

step-6
Tableau Skyscraper