topic Re: Cascading Multi-selects: Only showing unique choices in ArcGIS Survey123 Questions

Cascading Multi-selects: Only showing unique choices

AlfredBaldenweck — Fri, 27 Aug 2021 21:46:37 GMT

I have a list describing the contents of someone's closet. I'm taking inventory of this closet while I fill out this survey, but I really only care about what colors are represented in the assemblage. So I want to know what color shirts are in the closet, regardless of what style they are.

Example table (pivoted for readability)

Item Type	Item Style	Colors possible in that Style
Shirt	Collared	Blue (Navy), Blue (Pale), Green, Red
	Henley	Blue (Pale), Grey, White
	T-Shirt	Green, Grey, Purple, Red
	Tank-top	Black, Blue (Navy), Grey, Green, Purple

If someone selects a Collared shirt and Tank-top, the full set of choices will appear.

Item Style	Colors possible
Collared, Tank-top	Blue (Navy), Black, Blue (Pale), Blue (Navy), Green, Grey, Red, Green, Purple

(Survey123 puts the choices as A[0], B[0], A[1], B[1], etc...)

Since I only care about the color of his entire collection of shirts, how can I make a clean list of unique choices appear?

Collared, Tank-top

Black, Blue (Navy), Blue (Pale), Green, Grey, Purple, Red

(If this were really what the survey was, I would cascade in reverse, starting with colors, then going to Styles, but that's not possible with my actual dataset.)

Thanks!

Re: Cascading Multi-selects: Only showing unique choices

DougBrowning — Mon, 30 Aug 2021 15:42:28 GMT

Have you looked at the allow duplicate choice option? Not sure but it may filter for you.

https://community.esri.com/t5/arcgis-survey123-ideas/survey123connect-choices-duplicate-names-amp/idi-p/1053712

Re: Cascading Multi-selects: Only showing unique choices

AlfredBaldenweck — Wed, 01 Sep 2021 00:01:14 GMT

Thanks for the response.

I tried setting it to "no" and leaving it blank, and both had the same result as leaving it as yes, which was the default.

I think that setting is supposed to be if you want your choice to show up under multiple filters, e.g. If the previous answer to the filter question was "Shirt", rather than having your choice show up after selecting multiple (e.g. "Shirt" and "Pants").

Another thing that might be adding a wrinkle to this is that Iʻm referencing an external csv for this question, so maybe that changes whether or not the setting applies?

Re: Cascading Multi-selects: Only showing unique choices

AlfredBaldenweck — Wed, 08 Sep 2021 00:07:39 GMT

Update 9/7/2021

I'm having some limited success by placing the relevant items for each color into one cell, then using

contains(Animal, selected-at(${Animal}, '0') or contains(Animal, selected-at(${Animal}, '1') or ...

Sorry, I had to change dummy data

The problem is that it won't kick in until the number of choices that are enumerated in this choice filter are selected. So if I go all the way up to selected index 3, nothing will filter until I have 4 choices selected.

I'm now trying to figure out how to make it not tied to the number of selections and could use some suggestions.

Thanks again!

Example photos:

Here is my choice list:

With Index up to index 1,
No Choices:

One Choice:

Two Choices selected:

Re: Cascading Multi-selects: Only showing unique choices

AlfredBaldenweck — Thu, 09 Sep 2021 00:03:46 GMT

Update 9/8/2021

Good news! I have gotten it to work.

Bad news: It is extremely tedious to set up.

Using the data I shared yesterday, this code will work for all of the options.

if(count-selected(${Animal})=1, contains(Animal, selected-at(${Animal}, '0')), if(count-selected(${Animal})=2, (contains(Animal, selected-at(${Animal}, '0')) or contains(Animal, selected-at(${Animal}, '1'))), if(count-selected(${Animal})=3, (contains(Animal, selected-at(${Animal}, '0')) or contains(Animal, selected-at(${Animal}, '1')) or contains(Animal, selected-at(${Animal}, '2'))), if(count-selected(${Animal})=4, (contains(Animal, selected-at(${Animal}, '0')) or contains(Animal, selected-at(${Animal}, '1')) or contains(Animal, selected-at(${Animal}, '2')) or contains(Animal, selected-at(${Animal}, '3'))), if(count-selected(${Animal})=5, (contains(Animal, selected-at(${Animal}, '0')) or contains(Animal, selected-at(${Animal}, '1')) or contains(Animal, selected-at(${Animal}, '2')) or contains(Animal, selected-at(${Animal}, '3')) or contains(Animal, selected-at(${Animal}, '4'))),"")))))

You can't actually put line breaks in the calculation field, or else it breaks the formula, so in real life it's even harder to read than this.

I'm hoping that there's a way to have a javascript script evaluate the number of selected choices and then build the filter statement from there. My real life data is upwards of 80 choices to deal with (even after paring it down with other filters first), so writing this out for that many possibilities is not ideal.

I have a rough idea of what do, but don't know how to code well enough to make it happen.

Get the count of the selected in the question (X)
~~prepare statement S~~ I just realized this isn't necessary
- ```
"if(count-selected(${Animal})=", X, ", "
```
create a range from 1 to X, inclusive
For integer Y in that range, concatenate into one large string, U
- ```
"contains(Animal, selected-at(${Animal},'", (Y-1), "'))", " or""
```
Get rid of the last "or", ~~replace it with~~
```
"), "")"
```
~~Concatenate S, U~~ Return U

Specifically what I don't know how to do is creating a range, and then getting rid of the last "or".

Thanks!

Re: Cascading Multi-selects: Only showing unique choices

AlfredBaldenweck — Mon, 13 Sep 2021 23:35:03 GMT

Okay, I have a working solution.

The code to generate the if() statements is

It's not the ideal solution; originally I had created a script that worked dynamically. Unfortunately, S123 can't use formulas that are the result of a pulldata() or are the values in another question as filter expressions; it instead tries to filter based off the string of the expression.