Search
  • James Goodall

Tableau Bitesize: Progress To Target - Progress Bar Chart

This post will detail how to create a progress bar chart that shows progress towards a 100% goal



Essentially this is a 100% stacked bar chart, and as such there are a few ways to achieve this, but I’ve gone for a dual axis approach as described below


This, together with the other blog posts in the ‘Progress to Target’ series will use the ‘progress_dummy_data.csv’ file attached below:


progress_dummy_data
.csv
Download CSV • 17KB

This file contains dummy data related to 5 teams – it has just 3 columns: ‘ID’, ‘Team Name’, and ‘Target Met’ and is therefore recording which teams have met their particular (generic) target


As with the other blog posts, start off by creating a parameter from the ‘Team Name’ field:




Next, create a calculated field called ‘Team Filter’ as follows:



[Team Name] = [Team Name Parameter]


Then drag this to the Filters card and select ‘True’



You can then choose a team from the list of parameters – in this example I will be using ‘team_3’


OK so let's set up the calculated fields we need for this one (not many don't worry)


1



MIN(1)


‘Total Met Target’:



SUM(IIF([Met Target],1,0))


This one simply records a ‘1’ value whenever the team has a TRUE value for the ‘Met Target’ field which we can then use to calculate the %


% Met Target



[Total Met Target] / COUNT([progress_dummy_data.csv])


OK and that’s it – we can start building the view


Drag the ‘1’ field and the ‘% Met Target’ field onto the ‘Columns’ shelf and set them as Dual Axis (remembering to Synchronise the axes)



Change both mark types to a Bar Chart and adjust the size and colours (as usual I picked a washed out grey for ‘uncompleted’ section and a bolder colour for the % completed)



Tick ‘Show Mark Labels’ on the ‘% Met Target’ mark, format to your choosing, remove all lines and borders and hide the headers



Now that was easy wasn’t it? I hope you found this useful but if you have any questions – please feel free to leave a comment below!


The workbook on Tableau Public below contains all of the chart types used in the ‘Progress to Target’ series, including this one




172 views0 comments

Recent Posts

See All