Hi all,
I have two layers in may map:
- A layer consisting of 10km grids
- A layer for users to mark the location of insect traps placed in the field
I want to set up a count on the grid to show how many traps have been placed within that grid. I have tried the following Arcade but all I seem to get is errors. Any idea on where I'm going wrong?
// Count all traps in grid square since 30/10/2023
var traps = FeatureSetById($map, "186ca9c0d27-layer-24")
var sql = "created_date >= '30/10/2023'"
var trapFilter = Filter(traps, sql)
var countTraps = Count(Intersects(trapFilter,$feature))
return countTraps
Thanks