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.

The Data

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:

Calculated Fields

We will create a Path (bin) object by:

  • Right click on Path
  • Go to CreateBins…
  • 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.

Worksheet

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.

If you want to learn more about Creating Bespoke Data Visualisations in Tableau, do check out our course on Udemy at https://www.udemy.com/creating-bespoke-data-visualisations-in-tableau and using the coupon code TMWEB2019

6 COMMENTS

  1. Great Article Toan,

    How to disable these Unccessary tool tips.

    And show only needed data,
    When hover-over the bins data is showing in tool tip ,
    Just want to show party Votes

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.