idea Add a distinct count function to the Text widget to ExB in ArcGIS Experience Builder Ideas

Add a distinct count function to the Text widget to ExB

ChipMorgan65 — Tue, 31 Jan 2023 16:53:06 GMT

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).

Re: Add a distinct count function to the Text widget to ExB

Hels77 — Sun, 09 Feb 2025 01:39:04 GMT

This is from 2023. What is everyone doing as a work around?

Re: Add a distinct count function to the Text widget to ExB

D_Atkins — Tue, 18 Mar 2025 18:28:22 GMT

@Hels77

I think I've got one!

Experience Builder can utilize a Column Chart to establish Categories from a Field. Then, you can use the "Output" of the chart in the Dynamic Content of the Text Widget: 'Count' based on the 'field' will yield your count of Distinct/Unique values. (Let me know if I can provide some more detail.)

Note that this is not nearly as robust a solution as we'd like, i.e.:
Unique values in a List widget - Esri Community

Re: Add a distinct count function to the Text widget to ExB

Hels77 — Wed, 14 May 2025 23:50:16 GMT

Thanks @D_Atkins I'll give that a go!!