Error when trying to return count on Filtered Point data

Question

Hello,

I have tried to get a point count with a polygon using the following code:

// address count agol
var p = Portal('https://www.arcgis.com')

// Filter portal layer

var features = Filter(FeatureSetByPortalItem(p, 'xyzxyzxyz', xy), "feature.xy = 'xy'")

// get the points inside the current polygon feature
var points_in_polygon = Contains($feature, features)

// count them and return the number
return Count(points_in_polygon)

However I get the following error:

Invalid expression.
Error on line 1.
Failed to query statistics

When I run it as:

var p = Portal('https://www.arcgis.com')

var features = Filter(FeatureSetByPortalItem(p, 'xyzxyzxyz', xy), "feature.xy = 'xy'")

It runs perfectly but that does not do me any good.

Want I want to do is filter a point layer for specific values and return the count of the features that meet the filtered parameters within a polygon. I can return a value without the filter but for some reason I cannot get it to run when filtering.

Any help is appreciated!

Thanks,

kenbuja · Answer

Esri can be frustrating like that sometimes!

What was the final solution? You should click the "Accept as Solution" button in the post with the correct solution (even it was yours!). This will help others search for the same sort of answer.

Strata_ChrisG · Answer

Apologies, completely forgot to reply. This did end up working for me as I was able to get my model running soon after.

I will say ESRI is a little confusing as I essentially tried this prior to my other code and it did not run. Not sure if you ever had the experience of arcade scripts running one day and not the other.

Thanks anyways!

kenbuja · Answer

If I am understanding your data correctly, your code would look like this

// address count agol
var p = Portal('https://www.arcgis.com')
var features = FeatureSetByPortalItem(p, '9cf1341131214c15b7900f0153557246', 30)

//filter point layer for fiber only
var fiberFeatures = Filter(features, "Coverage = 'Fiber'")

// get the points inside the current polygon feature
var points_in_polygon = Contains($feature, fiberFeatures)

// count them and return the number
return Count(points_in_polygon)

Setting a variable to be used in the sqlStatement (variable substitution in the Filter function) means you don't have to worry about whether to use quotes.

var value = 'Fiber'
Filter(features, "Coverage = @value")
// or
var value = 99
Filter(features, "numericField = @value")

It's more useful when you have to get a variable from the incoming feature or make some a calculation, since you can't use Arcade profile variables like $feature or Arcade functions in the sqlStatement

var averageValue = Average($layer, 'POPULATION')
var result = Filter($layer, 'POPULATION > @averageValue');