Count of a choice from numerous select_one question

162
2
Jump to solution
05-20-2021 01:58 PM
ÉmilieBerthiaume
New Contributor II

Hi,

In my survey, I have a repeat on plant species for which I have two select_one questions: Is it a dominant plant (answer yes or no) and what is the "statut" (it's french for "status"...) of this plant (answer: OBL, FACH or NI).

I want to count the number of dominant plants for which the "statut" is OBL or FACH, and the number of plants for which the status is "NI"

Based on what I understood form this page: https://support.esri.com/en/technical-article/000021063

I have tried the following: 

ÉmilieBerthiaume_0-1621544066580.png

It is not working...  Could anybody suggest a way to acheive this?

Thanks!

Émilie

0 Kudos
1 Solution

Accepted Solutions
DougBrowning
MVP Notable Contributor

You do not want your numbers to be text so just 1 instead of '1'.  Then in the bind type column set it to int.  (Also note you can set bind esri type to null then they wont show up in the data)

Also set them to calculate type not hidden, works better.

That should so it.

View solution in original post

0 Kudos
2 Replies
DougBrowning
MVP Notable Contributor

You do not want your numbers to be text so just 1 instead of '1'.  Then in the bind type column set it to int.  (Also note you can set bind esri type to null then they wont show up in the data)

Also set them to calculate type not hidden, works better.

That should so it.

0 Kudos
ÉmilieBerthiaume
New Contributor II

Thanks, it worked!

I ended up changing a little bit my formula like this:

ÉmilieBerthiaume_0-1621603660416.png

And it did exactely what I wanted.  Thanks a lot for your help on this,

Émilie