I would like to create a Gantt chart in ArcGIS Dashboards to track dates/ duration days for a permitting timeline project. We have a permit process that requires multiple groups submit permits for a single location. Since Gantt charts are not native to the dashboard, I am planning to use a data expression. I found a post that references using data expressions to make a "quasi" Gantt chart, but I could use a little more specific assistance in the data types needed and execution of the data expression.
https://community.esri.com/t5/arcgis-dashboards-questions/gantt-chart/td-p/1310961
For example, I have a table with date fields and duration days.
Name = Traffic Study
Initial Assessment Date = 6/6/25
Initial Assessment Days = 8
Review Start Date = 7/7/25
Review Period Days = 45
I appreciate the help!