Data Visualization Tableau

How to create Gantt Charts in Tableau

If you are looking to visualize the project schedule or timelines, then Gantt charts in the tableau can be very helpful.

It can also be very helpful if you would like to share the dependencies and duration of the project. Also, it can be used to visualize how different members of the team have been utilized in different projects. Gantt charts in the tableau is a directly available chart and can be fetched from show me option.

To create Tableau Gantt chart, we should have the following measure/dimensions-

  1. 1
    1 Date
  2. 2
    1 or more dimensions
  3. 3
    0 or 2 measures

Tableau Gantt Chart Use cases

1. If we have to show how each resource of the team has been allocated to different projects in specific time duration, then Gantt chart in tableau is the solution.

Sample Gantt Chart Tableau

2. If you have to find in a particular month which shipping mode has shipped maximum orders, then also Tableau Gantt chart can be used. For this post also, we are going to use the same example and dataset.

3. Can be used to find the waiting time in hospital

4. Duration of any event and popular one

How to create Gantt charts in Tableau

Please follow the below steps to easily create Gantt charts in tableau-

1

Add Data

Drag order date to the column shelf and make it to continuous

Add data in tableau

Now as you will be seeing it on year aggregation and so convert that into the date. For that right-click on it and select days

convert year to date

Make sure after that also, it is in continuous view.

Learn Tableau From Scratch in $10

Learn Tableau step by step from scratch. It has an average review of 4.2 on Udemy and many learns have appraised it. Click the link below to get it at the discounted price of just $10.

2

Add More Dimensions

Drag subcategory and ship mode dimensions to the rows shelf and keep the marks as automatic.

Add dimensions in tableau

3

Add Filter on Date

For a better view, let's filter this chart on the date to view the data for one month. I have selected for the February month of 2014.

Add Date Filter Tableau

4

Create Calculated Field

To find the duration of time between the item was ordered and was shipped, we can create one calculated field. And then can use the function DATEDIFF() to find the difference in days.

Create Calculated Field Tableau

5

Use Calculated Field

Now let's drag the calculated field in the size shelf in marks. As we have numerical data in this calculated field (day) and so, Tableau will automatically aggregate it to SUM(). But convert it to Average to make more sense. To convert SUM() to AVERAGE(), just click on it select AVERAGE.

Use Size Shelf Tableau

6

Use Ship Mode in Color Shelf of Marks Card

We have already created Tableau Gantt chart but if you want a more clear view, let's add ship mode dimension in the color shelf in the marks card.

Use Color Shelf Tableau

This clearly shows that in Feb 2014, most of the orders were shipped by standard class shipping mode. Even though the first-class shipping method has also become popular around Feb 9, but still standard class is the showstopper.

Wrapping It Up!

These were the easiest way to create Gantt charts in Tableau. We have used that using a sample superstore dataset and you can use a similar technique for your own project needs. Do try and let us know if you find any issue while doing it. For more such tutorials, please check this link.

Leave a Comment