idea Count select multiple in ArcGIS Survey123 Ideas

Count select multiple

MattMulder — Tue, 04 Feb 2020 20:31:52 GMT

It'd be great if there were a way to create a count of how many times a property was selected from a select_multiple option.

I.e. If you have a grid index .svg and you wanted to create a count of how many times a sighting of an animal occurred within a grid while surveying simply selecting the grid section from the display.

The idea would then be to have a separate field for counting the number of occurrences grid "A1" was selected

The current workflow appears to submitting each time or having it through a repeat.

Re: Count select multiple

Kanin — Tue, 04 Feb 2020 22:19:24 GMT

Could you try using the count-selected(question) function in the calculation column? More details about this functionality can be found here.

Function	Description	Example
count-selected(question)	Returns the number of selected answers. Used for select_multiple questions.	count-selected(${question_one})

Re: Count select multiple

MattMulder — Wed, 05 Feb 2020 13:46:04 GMT

Hi Kanin,

wouldn't this function only count the different selections for the given question. You wouldn't be able count "repetitive" choices of "option 1"?

1 = selected

2 = no

3= selected

count-selected function: count is 2

Re: Count select multiple

NathanBruce1 — Tue, 11 Feb 2020 16:53:11 GMT

This would be good for a Traffic Count App that my coworker is toying with.

Re: Count select multiple

JamesTedrick — Tue, 25 Feb 2020 18:57:40 GMT

Hi Matt,

By your description, it sounds like what you want is already offered through a repeat, as each observation is an independent record. As part fo the design of the repeat, you can then have a calculate question flag which choice was selected using if(selected({$q},'choice'),1,0) and then use sum(${calc_q}) to total the number of observations

Re: Count select multiple

MattMulder — Thu, 27 Feb 2020 20:46:06 GMT

Hi James,

Thanks for your reply. This was the initial approach we went with, however based on feedback from the field user the added element of essentially "refreshing" the selection page via a repeat became an issue with some quick selections of the same choice.