Displaying time spans with Arcade in dashboards

DEI — Thu, 08 Apr 2021 13:32:48 GMT

Hello!

I copied and slightly modified code from the following Blog: https://www.esri.com/arcgis-blog/products/ops-dashboard/real-time/displaying-time-spans-with-arcade-in-dashboards/ (Many thanks to @David Nyenhuis and @Noora Golabi).

As my map gets updated, the seconds displayed start out in reverse like a countdown (54, 48, 42... to 0) and then proceed as expected (6, 12, 18...). The countdown shows up whether I specify type 1 or type 2.

Can anyone please tell me why I'm getting the countdown?

Here's what I'm using:

var dateOpened = $datapoint["last_edited_date"];
var currentTime = Now();
var secondsOpen = DateDiff(currentTime, dateOpened, 'seconds');

var timeFormatted = formatElapsedTime(secondsOpen, 1);

return {
attributes: {
timeFormatted: timeFormatted
}
}

Re: Displaying time spans with Arcade in dashboards

jcarlson — Tue, 21 Dec 2021 17:53:09 GMT

In your custom function, you're setting the numSeconds to an Abs value, so when your DateDiff returns a negative number, it's flipping it positive.

In the linked post, the authors do this so that the output is simply a duration, and is not concerned with the "direction" of the span. But the way DateDiff functions, given DateDiff(date_a, date_b, units), if date_b is after date_a, you will get a negative duration.

As far as why you're getting a negative duration between "now" and the last edit timestamp, that's a bit of a mystery. The implication is that somehow dateOpened is coming in at a future date. You may need to check on the source of the data to see if it's configured properly for time zone, etc.

topic Re: Displaying time spans with Arcade in dashboards in ArcGIS Dashboards Questions

Displaying time spans with Arcade in dashboards

Re: Displaying time spans with Arcade in dashboards