Creating gantt chart visual

[teja1]

I have noticed that the Gantt chart visual type isn’t available in Quicksight. However, I’m wondering if there’s a workaround to achieve this visual.

This visual illustrates a Gantt Chart displaying the timeinterval of each program (A, B, C, D) between their start time and end time.

I have data fields like starttime,endtime,programname(A B C D are the programnames on the above image), and timeinterval.

If anyone has ideas on how to create a Gantt chart using these data fields in Quicksight, I’d greatly appreciate the help!

[DylanM]

Hello @teja1, so currently there is not a visual type within QuickSight that will create a Gantt Chart. I’m honestly not sure if there is a good alternative to developing a visual similar to this either other than display the data points you want in a table. Maybe one alternative would be to utilize the custom visual content option if you have this chart displayed elsewhere and linking it in your QuickSight dashboard. I’ll link some documentation on that visual type below:

Using custom visual content - Amazon QuickSight

Let me know if that helps!

[David_Wong]

Hi @teja1,

Take a look at this post:

Create a Gantt Chart in Quicksight

I also used this for an absence / annual leave tracker, but added reference lines to denote the months. [image] Hope its a useful addition… Thanks Stuart

[David_Wong]

@teja1 The last reply in that thread has a link to Arena. If you click on it, you can copy the analysis and see how it was implemented.

[DylanM]

Hello @teja1, while I am not sure what exactly is going on in your screenshot above or what the issue is that you are experiencing, I know you can use the dateDiff calculation in QuickSight to calculated the time interval between starttime and endtime. Depending on how you want the time interval to be calculated, days, minutes, seconds, etc, you can get the difference between the 2.

timeIntervalInMinutes = dateDiff({starttime}, {endtime}, 'MI')

With that calculation, we can try to find some alternative ways to display the data you want represented.

[DylanM]

Hello @teja1, I see you have removed your comments from this topic. I will mark my previous response as the solution, but if you have any follow-up questions, please let me know!