Using GANTT Diagram with tierce API/Arcade/whatever ?

Question

Hi guys,

I want to integrate a chart (like gantt chart) to visualize for one company (corporation) the open and closed date of all of his establishment (physical structure) like this :

In green you have the current opened establishments, and in red the closed establishments. So with this representation you can see the company comportment by the time (how much establishment he’s opened, how much was closed, during which time ?, etc).

I'm working on experience builder, but the Chart widget can't do anything like that.

So I want to know if I can exploit Arcade with the pop-up to make a graph like the screen above ? maybe using an api chart (quickchart.io ?) or anything else ?

JasonBOCQUET · Answer

Hi @jcarlson with the last thread where you helped me yesterday : https://community.esri.com/t5/arcgis-online-questions/arcade-how-to-retrieve-all-values-which-has-a/m-p/1505463#M60239

we have succeeded to retrieve the data with the same ID than the point that I clicking on.

Do you think it is possible by this way to apply the same process to retrieve creation date of societies and to insert theses dates found in a chart to make what I  want in my opening post possible ?

JasonBOCQUET · Answer

hi @jcarlson thanks for your answer

Dashboards seems to be good but limited for my using.

My application is an Experience Builder so Dashboard is not the best way because it's not very dynamic on an experience builder.

And another point that I forgot in my post : I filter the dataset so see only head of office establishment, and I want, company by company, made a chart that recover all other lines in my dataset of the secondary establishments that belonging of the head of office establishment. All of this in the representation type that i share in my screenshot opening post.

Maybe a dream ?

jcarlson · Answer

I've messed around with Data Expressions in Dashboards to try and get a Gantt chart, or at least something like it. I posted about it here:

https://community.esri.com/t5/arcgis-dashboards-questions/gantt-chart/m-p/1311023/highlight/true#M8149

It's probably the best you can do within the Esri-verse, but you could also create the chart elsewhere and just use the embed widget, too. Mermaid.js works great for Gantt charts, and I believe you can embed the chart if you have it saved there.

https://mermaid.live/view#pako:eNpdUMFqwzAM_RWhs1Mix2lW3wphO_XUXTZyEbXXhS52SR1YF_Lvs5eUbnsYLD2954c14sEbixqP7EJoHESENnxY2MJToqBu-dhzN48MB_vo-44DwEtEtttldT3PLvYQWu9gP98zuYXAlxPcoZkEyJxUllM8AorcLFLnw7vt7wbNbyH2TADJYv7GLPKZfE6e1qXhEnOLIJncJBc3_w8BDVIZFNjZ-K3WxFWMSdpg1HW2QR1Lw_2pwcZNUcdD8PurO6AO_WAFDue0lGVLN_LM7tX73y3qET9RE602ZZ5LqlRRVUqREniNtCpXpdoUa0kPck2VnAR-_TxA0zdrynf6