topic Re: Convert Elapsed Time in ArcGIS Dashboards in ArcGIS Dashboards Questions

Convert Elapsed Time in ArcGIS Dashboards

shildebrand — Fri, 06 Aug 2021 18:38:14 GMT

Does anyone know if there is a way to convert a known length of time (in this case the number of minutes estimated for a sewer overflow) to hours, minutes, and seconds? Currently I am displaying the number of minutes (stored in a double field in a feature service) as an indicator in my dashboard. Any suggestions would be greatly appreciated.

Re: Convert Elapsed Time in ArcGIS Dashboards

jcarlson — Fri, 06 Aug 2021 18:54:54 GMT

You can use the built in value conversion in an indicator.

If that 50 represented minutes, converting it to hours would be as simple as applying a factor of 1/60, or .01666, and the result is now in hours.

Re: Convert Elapsed Time in ArcGIS Dashboards

shildebrand — Thu, 12 Aug 2021 22:08:10 GMT

Thanks Josh, that's better than showing minutes. Any thoughts on how to represent the hours and seconds? I'm thinking there is probably some kind of arcade expression that could be written.

Re: Convert Elapsed Time in ArcGIS Dashboards

jcarlson — Fri, 13 Aug 2021 13:15:07 GMT

Ah, you mean like "2 hours, 26 minutes, 15 seconds". That would have to be an arcade expression. For an example, I'll use 137.9 minutes. This is using a feature-based indicator with Arcade enabled.

var dur = $datapoint['duration-field'] // 137.9 used for test var s = (dur * 60) % 60 var m = Floor(dur) % 60 var h = (Floor(dur) - m) / 60 return { topText: `${dur} minutes`, topTextMaxSize: 'medium', middleText: `${h} hours, ${m} minutes, ${s} seconds`, middleTextMaxSize: 'large' }

Which results in:

Re: Convert Elapsed Time in ArcGIS Dashboards

shildebrand — Fri, 13 Aug 2021 15:39:21 GMT

Thanks Josh, that was exactly what I was looking for! I appreciate your time and effort on this!

Re: Convert Elapsed Time in ArcGIS Dashboards

Philip_Ohlinger — Thu, 31 Oct 2024 15:53:58 GMT

Is there a way to do this on a dashboard with a conditional indicator (based on a calculation?) I have indicators that show the 90th percentile time, and will be green or red depending on if it is over the benchmark or not. The data is stored in a double field as minutes, but ultimately we'd love to display the times on the dashboard in the hh:mm:ss format. Not sure if this is possible?