Text Widget to Dynamically Count Features based on Field Value

Question

I'm trying to set up a text widget with a dynamic count of features filtered by a field (e.g. RecordType = Club). The count will change based on map extent and user-selected filters. But I've found that:

* There is no direct way to filter based on a field within the text widget.
* The Expression module does not accept sql statements like 'where'.
* I have fields that are only populated for clubs, e.g. 'ClubAffiliation' but a Count of these returns the count of distinct values, not the total number of values (as stated in the documentation).

My data has a large number of features (up to 20,000) and will have a lot of concurrent users, so I'm conscious of performance. So trying to avoid using Arcade or creating Views just for this purpose.

Any ideas or wisdom, thanks?

DarraghOSullivan · Answer

Thanks @JeffreyThompson2 ,

Yes I might do that but was trying to avoid views with thousands of features if possible for something that seems quite simple! If setting up views, is it more efficient to set them up within ExB or externally, where I can reduce the fields etc?

Jeff.Thompson@arlingtontx.gov_arlingtontx · Answer

Could you set up Data Views to handle the SQL part of the problem? I don't think this should significantly impact performance.

You should be able to use Count on the OBJECTIDs to find the total number of records in the filtered dataset.

DarraghOSullivan · Answer

Thanks @StuartMoore . I think with Arcade now possible within a text widget in ExB, it would be more efficient than a dashboard embed. I also need continuous refresh, even as the main map pans etc.