Show points when count of attribute is greater than n

Question

Hello

I have a load of point data which i have filtered down to just show business properties, which works fine.  I am now trying to show only those properties where the number of premises on a street is greater than n.

I know I am missing something simple here, but how do i show only those records when the count of the street is greater than or equal to 'n'?

street 1 ID - count 5 do not show

street 2 ID - count 10 show

Thanks

Bud · Answer

Can you explain why a definition query won’t work?

Can you provide a screenshot of your data including the attribute table?

Ed_ · Answer

One way could be Arcade, now I am not an Arcade expert but this, Symbology, Arcade and Group By  might help.

Another option could to be use the `Summarize` tool to get a `count` column for `n`, then join (Join Field tool) that `count` column from the summary statistics table to your point data. After the join, run a query where `count` is `5` do not show and show. Hope this helps, cheers and good luck 🙂