topic Re: Count of a choice from numerous select_one question in ArcGIS Survey123 Questions

Count of a choice from numerous select_one question

ÉmilieBerthiaume — Thu, 20 May 2021 20:58:42 GMT

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:

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

Thanks!

Émilie

Re: Count of a choice from numerous select_one question

DougBrowning — Thu, 20 May 2021 22:37:23 GMT

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.

Re: Count of a choice from numerous select_one question

ÉmilieBerthiaume — Fri, 21 May 2021 13:29:35 GMT

Thanks, it worked!

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

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

Émilie