Progress Bar Chart in Tableau

Today we’ll be learning to creating Progress Bar Chart in Tableau. I’ll be using superstore data of the tutorial.

In the first step we’ll create a basic bar chart. So put discount in the Columns shelf and Sub-category in Rows shelf.

1-compressed

 

Now we’ll create a calculate field. For that go to analysis > create calculated field as shown in image below.

WINDOW_MAX(AVG([Discount]))
WINDOW_MAX()-
Returns the maximum of the expression within the window. The window is defined by 
means of offsets from the current row. Use FIRST()+n and LAST()-n for offsets from 
the first or last row in the partition. If the start and end are omitted, the entire
partition is used.

 

2 Calc Field-compressed

 

Now add the calculated field we just created to the Columns shelf.

3-compressed

 

Now make it dual axis.

4-compressed

 

We’ll see some thing like this. First of all make sure all the chart type should be Bar type and then change the transparency to somewhere around 50% and change the background to black(optional).

5-compressed

After some formatting we’ll get the following viz.

Final-compressed

 

So that’s done about the progress bar chart in Tableau. It can be used to make your final dashboard or Presentation look better.

Keep visiting Analytics Tuts for more tutorials.

 

 

2 comments

  • Great! Thanks a lot, Niket. I was wondering if we can do this using a Pie or Doughnut chart. If I have Total sales volume and I want to show the share of sales based on a filter (say based on time) to overall sale, how can we show that in a Pie or Doughnut chart? Can you help me with that? Cheers!

Leave a Reply

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