Arcade expression to locate matching records and produce total numeric values based on another field

DannySmith12

Hello all,

I'm attempting to create an arcade expression to do the following:

• Find all matching records based on a unique identifier (County ID)
• Use the matched records to find associated and varied acreage values
• Calculate a total for the associated and varied acreage values

 

Any insight will be greatly appreciated! Thank you.

JohannesLindner

// load the feature set using an appropriate FeatureSetBy* function
// see FeatureSetByID and below:
// https://developers.arcgis.com/arcade/function-reference/data_functions/#featuresetbyid
var fs = FeatureSetBy*(...)

// filter the feature set by county ID
// your scrrenshot shows field aliases, not names, check that I guessed the right name
var county_id = $feature.CountyID
var fs_county = Filter(fs, "CountyID = @county_id")

// return the sum of field "Acres"
return Sum(fs_county, "Acres")