Rounded Progress Bar 8


Facebooktwittergoogle_pluspinterestlinkedinmailFacebooktwittergoogle_pluspinterestlinkedinmail

Progress Bar

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 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:

Progress1

Calculated Fields

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

Progress2

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.

Progress3

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:

Progress4

Now with a bit of formatting, we can get the following:

Progress5

I hope you enjoyed this very, very, quick and simple Progress Bar in Tableau. As always please let me know your comments below.

Facebooktwittergoogle_pluspinterestlinkedinmailFacebooktwittergoogle_pluspinterestlinkedinmail

Toan Hoang

About Toan Hoang

Toan Hoang is a technology enthusiast with a broad understanding and appreciation of most aspects of technology but with a passion for Business Intelligence Solutions and Technologies, Data Management and Web Programming.


Leave a comment

Your email address will not be published. Required fields are marked *

8 thoughts on “Rounded Progress Bar