Supply Until Tear Off: dateDiff(${OriginDate}, {implementation_date}, ‘WK’)
Gap duration: dateDiff({implementation_date}, {min_ee_reach}, ‘WK’)
Supply after First Supply Date / Implementation Date: dateDiff({min_ee_reach}, ${TargetDate}, ‘WK’)
However I want to see the weeks in the X axis as in the first image. I am looking forward to change the schema to this:
SC_ID
EE/Component
Week_date
Phase
7401
TY67V
2026-W01
Supply before
7401
TY67V
2026-W02
Gap
Do you have any suggestions on how this type of graph could be created?
It’s essentially a Gantt chart, but Amazon QuickSight doesn’t support Gantt charts natively. I’ve seen that there’s also something called Highcharts, which allows charts to be configured using JSON.
Do you think Highcharts would be useful for building this type of chart? If so, do you think it would support the functionality I need?
Hi @01267ts,
In your last post that was covering the same topic, I suggested the highcharts option as your best work around since there is no native visual type that resembles a gantt chart.
You can see the sample code for the gantt chart option at the following link, on the samples tab: https://democentral.learnquicksight.online/#Dashboard-FeatureDemo-Highcharts-Visual
Please try and avoid creating duplicate posts to avoid information being spread out in various places for others’ to reference.
Following up here as it’s been awhile since we last heard from you on this thread; did you have any additional questions regarding your initial post or were you able to complete using a highchart?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Hi @01267ts,
Since we have not heard back further, I’ll go ahead and mark the solution. However, if you have any additional questions, feel free to create a new post in the community and tag this thread for relevance if necessary.
