topic Dynamic count of points inside a polygon in ArcGIS Dashboards Questions

Dynamic count of points inside a polygon

wizgis — Wed, 12 Feb 2025 15:53:34 GMT

Hi All,

We have the following scenario where there are points coming from survey123 and it is falling inside a polygon.

We wish to know if it's dynamically possible to reflect the count of points inside a polygon in any dashboard element (indicator, etc.). On researching this, we found that by using arcade expression, it is possible to reflect it in the pop-up. Following is the arcade expression that we have set up in the polygon layer

var points = FeatureSetByName($map, 'Point_layer') var countp = Count(Intersects(points,$feature)) return countp

We also found this link to the idea : https://community.esri.com/t5/arcgis-dashboards-ideas/using-custom-attribute-expressions-from-pop-ups-as/idi-p/1565798 , so this makes us think that it is currently not possible. However, data expression has been suggested however, we are not sure what should be the expression.

Any inputs would be helpful.

Re: Dynamic count of points inside a polygon

RPGIS — Wed, 12 Feb 2025 17:00:48 GMT

Hi @wizgis,

It is possible to do so in Dashboards. You would simply create a new feature set under "Data Expressions" and use the newly created data for any of the needed widgets in the dashboard.

The code below should give you some ideas on how to go about it.

var P = Portal('<portal url>') var Pnts = FeatureSetByPortalItem( P , '<item id>' , '<layer id>' , '<list of field names>' , True )// layer id is often 0 if the only layer var Poly = FeatureSetByPortalItem( P , '<item id>' , '<layer id>' , '<list of field names>' , True )// layer id is often 0 if the only layer var IntPntPoly = Intersects( Geoemtry( Pnts ) , Poly ) var GrpBy = GroupBy(IntPntPoly , '<layer name>', { name: '<custom field name>', expression: '<field name in layer>', statistic: 'COUNT' }) return GrpBy

Re: Dynamic count of points inside a polygon

wizgis — Fri, 14 Feb 2025 15:14:07 GMT

@RPGIS

Thank you for sharing your inputs however, had to modify the expression as Geometry function doesn't take feature set as input. Used the following link for reference:

https://community.esri.com/t5/arcgis-online-questions/arcade-data-expression-intersects-for-dashboard/td-p/1265441