topic Re: Auto-calculate/populate Response Time Field in ArcGIS Online Questions

Auto-calculate/populate Response Time Field

JasonCyphers — Thu, 02 Jun 2022 18:09:29 GMT

I have a hosted feature layer in AGOL with "Dispatch Time", "On Scene Time", and "Response Time" attributes.

Is there a way to automatically calculate and populate the Response Time attribute with the calculated difference between the On-Scene Time and Dispatch Time, in minutes? Something that is automatically done each time a new record is added, so that I can build a dashboard to show an Average Response Time indicator widget?

Re: Auto-calculate/populate Response Time Field

tigerwoulds — Thu, 02 Jun 2022 18:18:41 GMT

Arcade comes to mind...

How To: Calculate the difference between two date fields using Arcade in ArcGIS Pro (esri.com)

Re: Auto-calculate/populate Response Time Field

MaryAnne_VanZuyle — Thu, 02 Jun 2022 18:35:22 GMT

I am stuck on a similar issue right now. The DateAdd and DateDiff functions work in Map Viewer and Test perfectly in a Calculated Expression associated with an Atrribute in the form design. But it fails in Field Maps. I am wondering if these two Arcade functions work in Field Maps.

Re: Auto-calculate/populate Response Time Field

JasonCyphers — Thu, 02 Jun 2022 18:36:18 GMT

That's something I'd have to manually do though, correct? I'm looking for a way to do it automatically, anytime a new record is added.

Re: Auto-calculate/populate Response Time Field

tigerwoulds — Thu, 02 Jun 2022 19:28:09 GMT

You're right.

In order to do this, you would need to publish to ArcGIS Enterprise rather than using hosted feature layers in AGO. With ArcGIS Enterprise, you set up Attribute Rules in ArcGIS Pro, and publish your service from a registered data store. Then, your Response Time will dynamically update based on the Dispatch and On Scene values. Currently, AGO does not support Attribute Rules.

Another potential solution (although not 100% dynamic), write a python script using the ArcGIS Python API that will handle the calculation. If you put it on a task schedular, it can update the hosted feature layer in near real-time automatically.

Re: Auto-calculate/populate Response Time Field

JasonCyphers — Thu, 30 Jun 2022 16:14:03 GMT

Is there a way to display the difference between times (to get a response time) in a dashboard and an indicator widget? What would the arcade expression look like?