Browsed by
Category: Tableau Tips

Things that I have learnt or discovered that help me with Tableau

How to create a hex spiral unit chart

How to create a hex spiral unit chart

I didn’t manage to finish my “What’ the Harm?” dashboard in time for #IronQuest or with any degree of polish, but I did manage to come up with a new (at least for me) chart type: the hex spiral unit chart. I’m not sure it has that much data visualisation value, but it looks kind of pretty! This article describes how to build one: Background and alternative approaches For my What’s the Harm dashboard, it was critical for me that…

Read More Read More

My First Radial Diagram

My First Radial Diagram

After the recent Workout Wednesday polygon exercises, which relied on calculating x and y coordinates, I decided to try my first radial diagram. Can’t be that difficult, right? Actually, it was pretty easy! It just needed a bit of clear thinking about the calculations. Before I get into how it was built, you can see it on Tableau Public and below: Back to school – Trigonometry Full disclosure: I LOVED this stuff at school! And still do. I created the…

Read More Read More

Creating an anonymised version of a workbook

Creating an anonymised version of a workbook

(Adapted from a post on the Tableau Forums) I’m sure many of you that have had support cases with Tableau have heard the legitimate question “could you send the twbx file so that we can have a look?” You might have also heard it on the forums. Having a workbook to look at makes it MUCH easier for others to help you. However, if the dashboard contains personal data, this can be very difficult. As part of a support case,…

Read More Read More

Too many subtotals!

Too many subtotals!

I picked this tip up from a three-second part of Luke Stanke’s build video from his (now legendary?) 10/10 Workout Wednesday 2020 Week 18 Challenge. It was very quick and easy to miss. If you create a table, you have the option under “Analysis” to add ALL Subtotals: The result it subtotals at all levels of your table. Makes sense. But what if you don’t want ALL subtotals, just at certain levels? In this example, if I just want to…

Read More Read More

How I got to grips with table calculations

How I got to grips with table calculations

There’s a great mystique around the whole area of table calculations with LODs having stole a lot of their limelight. They range from very simple to incredibly difficult to get your head around. I’m still at the beginning of my discovery, but I wanted to share a tip about how some of the basic concepts started to find purchase on my neurons. I simply created the table below from the Superstore dataset, added SUM(Sales) to the table and used the…

Read More Read More