Arcade Issue Using Average or Mean in an Attribute Rule

427
0
12-03-2019 04:01 PM
MichaelBrown4
New Contributor III

Hello,

I'm having trouble using the Average and Mean function in an attribute rule.  I am intersecting points with a polygon being inserted/updated and wish to get the average of a field value from all intersecting points.  I am able to use the Sum and Count functions just find and my current workaround is to use both to get the Average. 

When I use Average or Mean, I first got an error about how the field name was used to run the function.  I was able to fix that by calling it differently (you can see the difference in the expression below).

The error I am getting now is below.

My Arcade expression:

var cpm_field = "Counts_Per_Minute"
var fsGS = FeatureSetbyName($datastore, "sde.blah.Gamma_Survey",[cpm_field],true)
var fsGSIntersect = Intersects(fsGS ,$feature)
 
var result_avg = null
 
if (Count(fsGSIntersect) == 0)
   return result_avg ;
else
   //result_avg =  Sum(fsGSIntersect,cpm_field)/Count(fsGSIntersect) My workaround
   //result_avg =  Mean(fsGSIntersect,cpm_field) Does not work
   result_avg =  Mean(fsGSIntersect,fsGSIntersect[cpm_field])
 
return result_avg ;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
0 Kudos
0 Replies