In my free time I try to build a few web applications, this is an essential part of my personal learning and attempt to keep relevant. Having an application that delivers great functionality is great, but what really sells it is a great looking set of dashboards so you can monitor your business; a way to see how things are progressing. As such, I have been scouring the Google for great Dashboard designs and one thing that keeps catching my eye is the rounded progress bar, as I love playing with Tableau, I thought I would give this a shot.
Again, I have used the UK Election as a data source to see what the number of seats where per party.
The source for our data is the British Broadcasting Corporation, otherwise known as the BBC: http://www.bbc.co.uk/news/election/2017/results
I have prepared and put this data into a text file that you can download: HERE
Once you import this data into Tableau you should see the following:
We will create a Path (bin) object by:
- Right click on Path
- Go to Create, Bins…
- In Edit [Path] set the Size of bins to 1
- Click Ok
The Path (bin) will allow us to use a table calculation to create additional data points between 1 and 100. If you do not get a smooth shape, by that I mean you can see the individual circles, decrease the size of the bins. Change this value to 0.5 and keep decreasing until you get what you are looking for.
Note: we are using the Path (bin) to densificate data and give us more points to work with. One thing to make sure of is that you check the Show Missing Values.
We will now create the following Calculated fields.
Index: This will be used for densification as well as resizing the overlapping rounded bars.
And we are done, we do not need much else to create this visualisation.
Let us create our worksheet.
- Drag Index onto Columns
- Drag Party onto Rows
- Drag both Party and Category onto the Color Mark
- Make sure Party is onto Top
- Keep your hand on control to select multiple objects.
- Drag Path (Bin) onto the Detail Mark
- Make sure that Path (Bin) has Show Missing Values set
- Right click on Index, go to Compute Using and select Path (Bin)
- Click on the Mark Type and select Circle
- Right click on Category and select Sort
- Put Values on top of Background
We should now see the following:
Now with a bit of formatting, we can get the following:
I hope you enjoyed this very, very, quick and simple Progress Bar in Tableau. As always please let me know your comments below.