Select to view content in your preferred language

How do I perform a distinct count operation in a text widget?

508
2
01-23-2023 02:20 PM
Labels (1)
ChipMorgan65
Frequent Contributor

I'm migrating a Dashboard over to ExB. I have an indicator that dynamically counts the number of species seen in a feature layer of plant observations.

In Dashboard, I'd add an Indicator widget with a Count statistic on the text attribute species, clicking the "Distinct" slider. This counts the distinct species in the feature layer.

I do not see a way to accomplish this in ExB. I've looked at the Dynamic functions, but they are numeric in nature. 

Any ideas?

2 Replies
KateSherman_psmfc
Emerging Contributor

Hi Chip,

Did you ever figure this out? I have a similar need to count the distinct organizations and include them in an indicator.

Thanks,

Kate

0 Kudos
JoshBerna
Frequent Contributor

Yah I also need this. Been fiddling around with the expression for so long but I can't get it to work. Shouldn't be so hard.

0 Kudos