nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Arcade expression for change since last edit?

ScottStopyak

I have a COVID-19 dashboard that needs to show the change in the number of cases since the last report. I have a table with a date field but the reporting isn't daily, so I can't just filter by things like "Today" or "Yesterday" etc. I need to find the max date and second to max date from the report records and report the change and/or rate of change.

The data looks something like this:

County	NewCasesToday	Date
Eaton	12	05/26/2020
Eaton	10	05/27/2020
Eaton	14	05/29/2020
Eaton	12	05/30/2020
Eaton	3	06/3/2020

I've used Arcade for simpler calculations, but this one has me stuck. Any help would be most appreciated.

Finde mehr Beiträge mit dem Tag

Accepted answers

XanderBakker

Hi Scott Stopyak ,

You could use Arcade to calculate the difference, but this would probably requiere a field calculation to use this in an indicator (if that where you want to show it). When I browse through the help for indicators (Indicator—ArcGIS Dashboards | Documentation ), it states this:

Reference values on indicators are optional and, when specified, can be thought of as a predefined goal or threshold. There are three types of reference values: the indicator's previous value, a fixed value set at design time, or a statistic calculated at run time.

Not sure if this works for your situation.

All comments

XanderBakker

Hi Scott Stopyak ,

Reference values on indicators are optional and, when specified, can be thought of as a predefined goal or threshold. There are three types of reference values: the indicator's previous value, a fixed value set at design time, or a statistic calculated at run time.

Not sure if this works for your situation.

ScottStopyak

Thanks, Xander. I think I can tease out the most recent report using max(date) but then I need to compare it to the second most recent report. Since I can't just say "yesterday" (reports don't happen every day), I'm stuck there. I imagine it must be possible to sort the dates somehow and choose the second most recent to use as a reference to compare to the most recent. I just can't seem to figure out how that would be accomplished in arcade. Maybe I have to do this calc on the backend with Python? I was hoping to avoid schema changes though, if I can.

Update: Now I see what you mean with the indicator. It has built in field {} calcs that refer to the previous value. That in conjunction with conditionally formatting for increases and decreases will work fine. Thank you!

ScottStopyak

The previous value setting didn't work for me after all. The data changed but the percent change remained zero.

XanderBakker

Hi Scott Stopyak ,

I'm sorry to hear that. Would using a field calculation or defining a scheduled task in Pro be an option you would consider?

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Anmelden
Registrieren

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.