idea Interactive Gantt Chart (Pro/AGO/Experience Builder) in ArcGIS Pro Ideas

Interactive Gantt Chart (Pro/AGO/Experience Builder)

MōnoSimeone — Mon, 17 Jan 2022 18:27:35 GMT

Any time-based project (think AEC; think emergency preparedness for events/event planning; think indoor/3D...etc) which relies on logistics or seeing data from multiple location (or activity at the same location) uses a Gantt chart view to better understand the data as well as to interact with the data.

Requirements:

Ability to select Gantt objects and have them highlight in the map and vice versa.
A time-slider that can manually or play across the Gantt chart
Chart configuration and use should be the same across all apps: Pro, AGOL, WAB, EB

Flora Vale‌

Re: Interactive Gantt Chart (Desktop/Pro/WAB)

ChristophHaeberli — Wed, 01 Nov 2017 12:07:36 GMT

great idea. Just confirm this need in the construction. The planner of the site needs tools like that to organize the project.

Re: Interactive Gantt Chart (Desktop/Pro/WAB)

DrewFlater — Fri, 19 Jan 2018 20:23:44 GMT

Can you explain the type of GIS data that you would use with this chart in an ArcGIS Desktop application? The example of wikipedia (Gantt chart - Wikipedia ) does not look much like GIS data.

Re: Interactive Gantt Chart (Desktop/Pro/WAB)

MōnoSimeone — Fri, 19 Jan 2018 22:19:28 GMT

We have a real use-case in that we track construction activities for logistical planning. The Gantt is used primarily as a scheduling tool but it provides a nice reporting visualization for our constituents to understand when and where activities take place that may impact properties adjacent or nearby. Impacting traffic, sidewalk accessibility, road/lane closures, events, etc.

A particular challenge for us currently is an area where we have over a dozen activities from 4 different contractors. All the activities overlay on top of each other - without a Gantt chart to manage the graphics it's very-very difficult to control/show activities to the stakeholders so they can properly plan and/or avoid each other in the same space. Again, in general, the Gantt chart provides a nice visual report for managers to push notifications to their clients/customers/services.

Christoph is correct this type of visualization is in need for construction (and is part of any construction management software) but any type of temporal planning/scheduling typically relies on a Gantt chart.

Happy to talk/show/give demo of what we have and our needs.

Re: Interactive Gantt Chart (Desktop/Pro/WAB)

MōnoSimeone — Fri, 19 Jan 2018 22:49:45 GMT

To follow up I should mention that my original purpose behind this feature request was the ability to pull IFC data from construction management software into Pro that would reconstruct the building and logistics plan in 3D. The IFC data held the schedule data for each activity (most activities include something physical occurring somewhere; fencing installed, mat poured, staging area moved...etc.) so theoretically one could use a timeline to visualize the construction of a building hour-by-hour, day-by-day. But this also works for horizontal projects such a laying utilities.

For non-construction use case, imagine law enforcement planning an event which requires things to occur at a certain time. Set up fencing/K-rails for pedestrian access, deliver modules for PD and event staff HQ, setup stage, gates open, place/shift officers at this location and at this time...etc. and then all the clean-up schedule.

Re: Interactive Gantt Chart (Desktop/Pro/WAB)

ZacharyOrdo__GISP — Mon, 12 Nov 2018 14:31:55 GMT

This is a fantastic idea. This would have wide-ranging applications, including in Oil & Gas and other utilities and transmission industries.

Re: Interactive Gantt Chart (Desktop/Pro/WAB)

GregHornbeek — Thu, 05 Dec 2019 17:18:39 GMT

I would love this too. Doesn't even really have to be interactive since it is a visual aid, but I have a need for this now. I have been trying to use Serial Chart Widget in operations dashboard, but not successful. We use it to track projects through the various stages of production as well. I can get close in OD, but just wish you could use dates in the Value Axis. We track expected start and completed dates, which would be the bar for the Serial Chart if dates could be used. All for this one!

Re: Interactive Gantt Chart (Desktop/Pro/WAB)

ColeAndrews — Fri, 23 Oct 2020 23:27:10 GMT

Mōno Simeone‌, I'm trying to understand how you want to source the Gannt, as Drew Flater‌ asked. You want the gannt to be based off of date field(s) in a feature class?

Re: Interactive Gantt Chart (Desktop/Pro/WAB)

MōnoSimeone — Mon, 02 Nov 2020 23:35:10 GMT

Cole Andrews‌, yes based on the feature class date fields. Gantt charts for scheduling rely on [start date] and [end date] of an activity.

A few other considerations if this was to be added as chart type in Pro/WAB/EB/OD...

Settings or options that would enhance a Gantt widget:

a) Range selection > user has the ability to set a date range to see only the activities within the user-defined date range; or, to define a date range as part of the Gantt chart, removing the ability for the user to change it.

b) Level selection: Typically, in construction or event planning, there are different "levels" to an activity "Level 1" is the rollup of all underlining activities. For example, the Level 1 activity may be to "repave road", this has an overall start and end date; Level 2 would be the more specific individual activities (each with their own start/end dates) such as grind pavement, replace catch basin, pour concrete, set asphalt, add lane striping. These 5 activities "rollup" to the main activity of repaving the road. Therefore, a P6, or Microsoft Project schedule may have several Level 1 activities, and each Level 1 activity has its own subset of Level 2 activities.This would also satisfy looking at a master schedule, each project would be a level 1 activity.

The user should have the ability to filter by a non-date field that expresses these "levels", so only to see Level 1 records, or the level 2 records, or both level 1 and level 2 records.

The user should also have the ability to filter by a specific Level 1 record. There might be several Level 1 activities, this would allow a user to focus/filter on a specific activity to be represented in the Gantt chart.

c) Display the activity duration as a numeric value next to the Activity (and have the ability to choose the time unit: days, months, years)

I can't believe it's been 3 years since I wrote this idea 😕

Re: Interactive Gantt Chart (Desktop/Pro/WAB)

NikHenryOz — Tue, 15 Dec 2020 05:02:32 GMT

@MōnoSimeone, this is a great idea.

Totally benefit the expansion of Workforce, being able to display assignments in on a Gantt chart within Operations Dashboard...........magic!

Re: Interactive Gantt Chart (Desktop/Pro/WAB)

MōnoSimeone — Sat, 19 Jun 2021 00:16:58 GMT

Has there been any 3rd party Gantt chart widgets built for Pro, WAB, or Dashboards?

Will need something in the near future to satisfy area-wide logistics.

Re: Interactive Gantt Chart (Desktop/Pro/WAB)

TimothyCallahan — Sat, 17 Jul 2021 02:23:44 GMT

Our City loses millions of dollars each year due to multiple independent agencies having (unbeknownst to them) project overlap.

Example: A street repaving is completed in July and in August the road is torn up for a new utility line.

It would be nice if our City could host an AGOL web app where each agency drew project boundaries in AGOL that link to a Gantt chart.

Re: Interactive Gantt Chart (Desktop/Pro/WAB)

MōnoSimeone — Sun, 01 Aug 2021 20:50:00 GMT

@TimothyCallahan @FloraVale a master construction activity/project schedule only gets logistics and planning so far - the hurdle is as you say is to "draw project boundaries...that link to a Gantt chart". This would enable logistic teams or planners/PMs to identify conflicts or opportunities as well as understand task relationships (dependencies) based on time and location, while maintaining a view project durations which provide the overall schedule view.

Gantt charts are critical in construction project scheduling and event planning because the planner/PM can visually view the project activities in a way that is logical to planning and managing the project(s) for "what if" scenarios, and to avoid delays and re-work. Microsoft Project, P6, and other PM scheduling software have become more open/exportable for other systems to use.

Adding a geographic link to a Gantt chart is not novel as existing project construction software does this with BIM data for both internal construction and site logistics; scheduling staging and material (or parking, Big rooms, etc.) around a construction site as the structure is being built.

Another scenario: 20 projects are scheduled on a segment of Street A over the course of a 12 months. One project's boundary covers the entire street segment while the other 19 projects are all smaller footprint boundaries but also overlap/cover each other. The time-slider will display all "active" projects as it relates to the time-range defined by the user (1 day, 1 week, etc) on the slider but as a planner/PM I need to see the list of projects, their duration, and how they relate to each other to leverage the geographic view presented to understand conflicts, opportunities, and dependencies. The time slider does not convey to the user that project A is just about to end, and project B has just begun, which a Gantt view would provide.

Re: Interactive Gantt Chart (Pro/AGO/Experience Builder)

RichardKoch — Sun, 03 Apr 2022 00:45:45 GMT

@MōnoSimeone , @ChristophHaeberli , @DrewFlater , I am late to the party here and as it will be discovered I have not posted before. This idea has brought me out of the woodwork. We are currently in the midst of a full UN conversion. couple that with a new DMS, ADMS deployment, and it's been a fun couple of years. I am writing now because there are several transformative projects happening within our company and I am trying to keep things aligned and useful to our GIS. One thing we are working on is a replacement for our current work scheduler. it is a Gantt chart-based unit that ties to our other work management systems. The current plan is to build this new program in-house. I have sent the internal team working on this project links to ESRI Workforce, and Field Maps but they lack the desired charting ability mentioned in this post. A standalone Ganatt that is tied to a feature layer and could possibly allow for adjustment of times and schedule from either the chart or map would be ideal. Would ESRI be interested in working on something like this?

Re: Interactive Gantt Chart (Pro/AGO/Experience Builder)

KoryKramer — Mon, 04 Apr 2022 13:30:51 GMT

Thank you for the comment @RichardKoch I took a look and it doesn't appear that you added your kudos to the idea. While comments are important, kudos (the number of votes) that an idea receives is one of the primary pieces of data that we use to determine traction and trends as we monitor idea activity over time.

Please see https://community.esri.com/t5/custom/page/page-id/arcgis-ideas for a high level overview of how ArcGIS Ideas works, and for detailed information.

Thank you for your participation in the community and for helping us prioritize future development efforts for ArcGIS Pro.

Cheers,

Kory

Re: Interactive Gantt Chart (Pro/AGO/Experience Builder)

RichardKoch — Mon, 04 Apr 2022 13:39:23 GMT

@KoryKramer Thank you. I will look over the links and look forward to more involvement as time permits. If there is anyone at ESRI who would like to discuss this please pass along my contact info and we can also check if @MōnoSimeone would be available since they are the OP.

Regards

Richard.

Re: Interactive Gantt Chart (Pro/AGO/Experience Builder)

MōnoSimeone — Mon, 04 Apr 2022 16:45:51 GMT

@RichardKochthe chart person for Esri is @FloraVale though this request is something of a mashup between a chart and the time-slider functionality - at least in my concept of the chart.

What may be helpful to this idea is to explain how you/your teams would use the tool because the first thing Esri does is ask why you can't achieve this functionality with the existing tools. For example, in construction logistics or event planning, in the GIS we want to be able to see how long each activity occurs (this is the gantt bars) to identify conflicts (aka clash detection) and then be able to click on a specific day/time or select a range of time and highlight those records in the map (and to be able to filter by a specific day/time or range). In addition, I need rollups in the Gantt chart to see the subparts of an activity.

One can almost achieve a gantt chart "look" with a bar chart in ExB but it's not a workable solution and falls short of what this request is seeking due to the additional parameters needed to get the expected behavior of a true gantt chart.

Happy to coordinate to push Esri on a solution.

Re: Interactive Gantt Chart (Pro/AGO/Experience Builder)

RichardKoch — Mon, 04 Apr 2022 19:43:38 GMT

@MōnoSimeone and @FloraVale so we are looking to replace something along the lines of a Click Schedule. ClickSchedule Web Client UI - V8 Documentation (clicksoftware.com).

Now I am not sure if we even use the mapping part of it currently. but in my GIS brain all I see if the idea of a chart that ties to a map with my assets on them since that is really what I am working against.

Our schedulers and "management" types would prefer a Gantt look. I am pushing a more Geo based solution. Found this discussion after talking with one of our internal resources close to the project, and of course the best of both worlds came to me.

SO in its best form the tool would source jobs from our work management software. This software is already tied to our GIS however not all work in it requires origination from the GIS. The work management has the times and dates in it. Scheduler would plan about two weeks out. Full integration would see dates initially set in Work Management and adjusted in the Scheduling phase either in the chart or in the map based on user levels and access. Initial schedule would likely come from the chart.

Benefits of doing this in ESRI....

1 - I could work out planning our own work on the smaller or internal only stuff, and when schedules need to shift see what's near where i was and update accordingly. map and chart working together for better visibility and planning.

2 - Larger State, Federal, DOT type work. I could work out a shared schedule with overlays and triggers so I do not plan work for tomorrow only to find I need to adjust on the fly to some last min change because someone on an opposing team forgot to call or update. Easier to call a few days ahead and say.... "You are still showing incomplete on X, and we cannot move until your part is done"... Can help everyone across the board in keeping a large job on track.

Regards

Richard Koch

Re: Interactive Gantt Chart (Pro/AGO/Experience Builder)

dreswartz — Wed, 20 Jul 2022 15:12:28 GMT

I work for the DoD and there is definitely a need for a gantt type of chart for scheduling.

If the gantt chart is interactive with the dashboard, as a person clicks through the gantt chart, changes within the dashboard (maps, media, images, charts etc.) would occur.

Furthermore I could see a benefit within storyboards. Storyboards already have a time-line feature but you have to scroll down to find the date. Why not just go to a gantt-type of timeline that summarizes the storyboard at the top of the storyboard?

The gnatt chart interaction with dashboard/storyboard is sorely needed.

Trying to bump up the post to make this a reality.

Re: Interactive Gantt Chart (Pro/AGO/Experience Builder)

LoganMcKay1 — Thu, 06 Oct 2022 16:29:25 GMT

There are several use cases for the gantt chart solution to be used to support military users. Operationally, phase lines can be drawn that have a start date and an end date along with logistics information can be analyzed to see if there are any geospatial or temporal overlaps that show inefficiencies. Scheduling maneuvers and training exercise locations to be able to request for certain support at specific times/dates and locations, eg: scheduling FMV assets to cover specific areas and providing both a schedule of flight and geographic location of flight coverage. Personnel calendars with location can be visually provided to security teams/administration support in order to plan trips, provide adequate security and have situational awareness of key personnel.