Select to view content in your preferred language

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

784
5
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?

5 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
Hels77
by
Regular Contributor

I also want this

 

0 Kudos
Lasya_Venigalla
New Contributor

You can use the COUNT operator under the Statistics tab or Expressions tab in Dynamic content window. 
COUNT({text_field})
DistinctCount.JPG

0 Kudos
Hels77
by
Regular Contributor

Thanks Lasya, but this doesn't do Distinct Count.

0 Kudos