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, Sum by key

BenjaminMittler

Hi All,

Im attempting to write an arcade expression an i'm a little lost. I have a layer where each day features are added for each county in our state along with a count for how many new COVID-19 cases occurred that day. I would like to write an expression that returns the sum of the count field for each individual county. If done correctly the expression would combine the daily cases for each individual county and i would be able to symbolize a map with the total cases for that county.

Can anyone point me in the correct direction?

Trouver plus de publications taguées avec

Accepted answers

XanderBakker

Hi Benjamin Mittler ,

That would require a field calculation that needs to be done every day to update the total amount of cases, since the symbology profile does not provide access to other data than the that held by the feature itself. So if you have multiple records for a county, you would need to access those records and calculate the sum. If doing a field calculation every day (or setting up a scheduled task in Pro to do this automatically) is not a problem, please post some more information on how your data is structures, to provide some more detailed information.

The pop-up on the other hand does have access to other layer and features and can provide a sum of the cases for each county.

All comments

XanderBakker

Hi Benjamin Mittler ,

The pop-up on the other hand does have access to other layer and features and can provide a sum of the cases for each county.

BenjaminMittler

Hi Xander,

Thanks for the help, the information provided is correct. I was able to get the arcade expression working in the popup but it is not supported within the symbology expression. I ended up having to create a field to host the sum data and created a script to rerun a field calculator expression daily.

XanderBakker

Hi bem08c ,

Thanks for posting back your solution. Hopefully we will be able to use attribute rules in ArcGIS Online soon, so you can trigger these calculations automatically when edits are posted and you won't have to create any scripts.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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