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 trouble with GroupBy function

clt_cabq

I have a layer of locations with a related table that contains 'calls for service' to a given location by police, fire, or code enforcement staff. I want to include in the pop up a breakdown of the types of alls made to each location, including the number of each unique type and a summary of a points score applied to each call based on the severity of the call type (for instance homicides get a 10, wiring infractions a 1). I think I can do this using a combination of the GroupBy function and FeatureSetByRelationshipName function. However, I keep running into a problem with the GroupBy syntax where Arcade flags the GroupBy statement and says it is an invalid variable assignment. I've modeled this after examples provided and can't figure out what i am missing in my code which is below. Any thoughts?

var CallsByType = GroupBy(FeatureSetByRelationshipName($feature, "AdaptLocationCallDetails"),
[
  {name:'Department', expression:'BU_SOURCE'}
  {name:'Type' , expression:'CALLDESCRIPTION'}
],
[
  {name:'Total',expression:'1',statistic:'COUNT'}
  {name:'Points',expression:'POINTVALUE',statistic:'SUM'}
]
);

Find more posts tagged with

Data and services

Mapping

Arcade

Accepted answers

Justin_Greco

The first thing that catches my eye is that you don't have commas separating the objects in the arrays. Also if this is the only line of your expression, make sure to return CallsByType (or don't even declare the variable).

var CallsByType = GroupBy(FeatureSetByRelationshipName($feature, "AdaptLocationCallDetails"),
[
  {name:'Department', expression:'BU_SOURCE'},
  {name:'Type' , expression:'CALLDESCRIPTION'}
],
[
  {name:'Total',expression:'1',statistic:'COUNT'},
  {name:'Points',expression:'POINTVALUE',statistic:'SUM'}
]
);

All comments

dcaESRIwvges

nevermind, I found the descirptions below.

dcaESRIwvges

I'm so glad i found this! I can't find a description of what is required for the GroupByFields and Statistics part of this function. I know name: in the first section is the field name, but what is the expression: in the first section and and what does the "name:" refer to in the last section or statistics? is this arbitrary? why is it expression: '1' and 'POINTVALUE', The ESRI help only gives some bad examples but doesn't explain the parts of the function. https://developers.arcgis.com/arcade/function-reference/featureset_functions/#groupby

Justin_Greco

var CallsByType = GroupBy(FeatureSetByRelationshipName($feature, "AdaptLocationCallDetails"),
[
  {name:'Department', expression:'BU_SOURCE'},
  {name:'Type' , expression:'CALLDESCRIPTION'}
],
[
  {name:'Total',expression:'1',statistic:'COUNT'},
  {name:'Points',expression:'POINTVALUE',statistic:'SUM'}
]
);

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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