GANTT Chart with Shapes

0 votes
I'm attempting to make something similar to a GANTT chart, where the start and finish dates are represented by a diamond shape, and the length of time between the start and end dates is represented by a line connecting the forms. Is there anyone who knows how to accomplish this in tableau?

I have an identification column, an event column, a date column, a start date column, and an end date column in my database for data.
Apr 11, 2022 in Tableau by Vaani
• 7,070 points
1,079 views

1 answer to this question.

0 votes

Put the start date on the column shelf and convert it to continuous precise date to construct a basic Gantt chart in Tableau. Change the mark type to Ghantt and place the identifier on the row shelf. This should result in a small bar at the task's start date, with a row for each task (assuming the ids are unique per task).

Now you must specify the length of the bars by adding a field to the size shelf that shows the number of days for each activity. You can use datediff('day, contract start, contract end) to determine their durations in a computed field. If you put that on the size shelf, you should be good to go.

You can expand the tooltips with more information and use colour to indicate contract kind or something else. By right-clicking on the axis, you can add some reference lines. To deal with situations like null (unknown) end dates, maybe recurring jobs, you'll need to change the computed field...

If you only need a few milestone markers, you can easily add them by hand using reference lines or point annotations.

You may also use a dual axis chart to integrate milestones as shapes with your data.

This example demonstrates how to mix shapes and bars into a single chart. The details change slightly depending on how your data is arranged, but you should be able to adapt the method to your own data if you look at how the data for this workbook is organised, how the data connection links the tabs, and how the workbook presents the data. Just keep in mind that it's occasionally easier to change the way your data is organised to make the analysis go faster.

You should also examine whether you require both planned and actual dates.

Ready to stand out in the world of data visualization? Explore our Tableau Certification Program and unlock a new realm of opportunities by validating your expertise in the industry's leading data visualization tool!

answered Apr 12, 2022 by Neha
• 9,020 points

Related Questions In Tableau

+1 vote
1 answer

Creating a Gantt Chart over time with summed bar

The trick with Gantt charts in Tableau ...READ MORE

answered Jul 21, 2018 in Tableau by Atul
• 10,240 points
963 views
0 votes
1 answer

Creating a dual axis chart with same measure in Tableau

Yes, this is possible. Drop the measure in ...READ MORE

answered May 29, 2018 in Tableau by Atul
• 10,240 points
8,750 views
0 votes
1 answer

Tableau chart with mixed colors

It is as simple as dragging the ...READ MORE

answered Jun 28, 2018 in Tableau by ffdfd
• 5,550 points
1,957 views
0 votes
1 answer

Tableau- Pie Chart with Multiple Measure Values

Hi Nithin, Pie chart is used to show ...READ MORE

answered Mar 11, 2019 in Tableau by Cherukuri
• 33,030 points
21,205 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,070 points
511 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

Is there an executable for Tableau Desktop ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,070 points
459 views
0 votes
0 answers

Tableau Map view Continent List

I've been attempting to tidy up my ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,070 points
578 views
0 votes
0 answers

Downloading tableau workbook from tableau server with data

I'm brand new to tableau server. I ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,070 points
588 views
0 votes
1 answer
0 votes
1 answer

creating a tableau pie chart with no measures data

It's not difficult once you understand the ...READ MORE

answered Apr 12, 2022 in Tableau by Neha
• 9,020 points
903 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP