Add a distinct count function to the Text widget to ExB

382
0
01-31-2023 08:53 AM
Status: Open
Labels (2)
ChipMorgan65
Occasional Contributor

There's a useful feature to the Indicator widget in Dashboard that I'd really like to see replicated in the Text widget in ExB. It allows you to do a distinct count of a text field. 

I envision a new function being added to the Text widget in ExB called dcount, or something like that. It would be used for text attributes where you want to count the number of different/distinct values of that field and not simply the number of rows in the feature layer. 

The screenshot below shows this feature in action on a dashboard. Note the distinct switch at the bottom center. In this situation, there are 2,950 distinct plant species in several hundred thousand plant observations in the feature layer (I have a companion indicator that shows the observation count, which I can do in ExB).

ChipMorgan65_0-1675183496604.png