Gantt Chart Visualization Type

Question & Answer
, ,
1

Has anyone been able to display relationship data like what’s available in a Gantt chart? I’ve searched here and on the web, where the answer appears to be “no”, but I’m wondering if someone has found a work around to do something similar or heard of any potential of QS to offer it as a visualization type in the near future.

2 Likes
2

First, I want you to know that QuickSight team has received requests to introduce Gantt chart from other customers as well. It might be added in 2022.

For the time being, you can get results similar to the image below

Screen Shot 2021-06-29 at 6.48.00 AM
Screen Shot 2021-06-29 at 6.48.00 AM1292×749 70.5 KB

Steps:

  1. Create a calculated field called MinDate with expression similar to “minOver(min({Start Date}), [])”. Value of this field will be equal to the earliest date you have in your dataset.
  2. Create a calculated field called Empty Period with expression “dateDiff( MinDate, min({Start Date}))”
  3. Create a stacked horizontal bar chart with Task on the Y axis and Empty Period and Duration of the task on the X axis.
  4. Hide X axis (since you probably don’t want to see numbers on the X axis. Unfortunately there is no way at the moment to show dates on the X axis)
  5. To see dates for the tasks, customize tooltips and show “Start Date” value in the tooltip.
  6. Change color for the “Empty Period” bars to match background of your chart and remove gridlines
7 Likes
3

Although that’s not exactly what I was looking for, It’s pretty close and I’m certainly going to play around with the idea.

Thanks!

4

I love this idea.
I been using Tableau for long time and the way you build the gantt chart is very similar to the way doing with Tableau. Especialy calulating with min Data and duration.
I also hope that there is the way to show date on x-axis! Thanks again for sharing the great idea. Tomi

1 Like
5

Here is a Gantt chart example on QuickSight Arena GanttChartExample

2 Likes
6

unable to add Empty Period to X axis

error: custom aggregation field is not allowed as dimension

1 Like
7

Is there any update as to when Gantt charts may be added, if at all? We cannot fully migrate from Power BI until this feature is added.