The Tableau Gantt Chart is very useful to visually display the duration of an activity or an event. In this article we will show you, How to create Gantt Chart in Tableau with example.
For this we are going to use the Data Source that we created in our previous article. Please visit Data Labels in Tableau Reports article to understand the Data Source.
Gantt Chart in Tableau Example
There are multiple ways in creating a Tableau Gantt Chart
Create a Gantt Chart in Tableau – First Approach
In order to create a Tableau Gantt Chart First, Drag and Drop the Country Name, and Color fields from Dimensions Region to Rows Shelf.
Next, Drag and Drop the Order Date from Dimensions Region to Columns Shelf.
Let me change this Text Label to Gantt Chart. To do so, Please expand the Show Me window and select the Gantt Chart from it
Once you select the Gantt from Show Me window, Gantt Chart will be displayed as shown in below screenshot.
Let me change the Order date value from Year to Week Number present in each year to see the detailed information
Now you can see the gantt chart that is displaying Weeks information
Next we have to specify the Gantt size. So, Drag and Drop the Order Quantity from Measures region to Size Card present in Marks Shelf.
Now you can see the proper Gantt Chart
Create a Gantt Chart in Tableau – Second Approach
First, Drag and Drop the Country Name, Color fields from Dimensions Region to Rows Shelf, and Order Date from Dimensions Region to Columns Shelf. Next, Let me change the Order date value from Year to Week Number present in each year to see the detailed information
This will automatically generate a Gantt Chart for you.
If this is not the case then, Please change the Marks field from Automatic to Gantt Chart
Next, let me add Color Dimension to Color Card, and Order Quantity to Size Card.
Generally we use Count Function for Order Quantity. So let me change the Default Sum to Count. To do so click the down arrow of SUM(Order Quantity) to open a drop down menu. Here, Select Measure (Sum) and then Select Count
By highlighting specific block will show you the information about that block
This time we will add Table Calculation that will calculate the Order Quantity Difference. In order to add, Please click on the Order Quantity and select the Quick Table Calculation option and then select the Difference as shown below
And you can see the result
Hover Over a block to see the information