topic Re: Filtering Single Option from Multiple Select Data Cell in ArcGIS Online Questions

Filtering Single Option from Multiple Select Data Cell

EMSpecialist — Thu, 06 Nov 2025 20:36:33 GMT

Good afternoon,

I have a survey that feeds data into a table. One of the questions has multiple choices and the user can select more than one choice, e.g. Option 1, Option 2, and Option 3. How can I filter this data to show only Option 3?

Thank you.

Re: Filtering Single Option from Multiple Select Data Cell

MobiusSnake — Thu, 06 Nov 2025 20:53:32 GMT

If you're using a client that supports SQL where clauses (like Select by Attributes in Pro, or the ArcGIS API for Python), you'd want something like this:

MyField LIKE '%OPTION_3%'

If you're using a web interface that requires an operator (like the item page's Data tab in the web interface), you want to use the "contains the text" operator.

It'll be important to give your options values that aren't subsets of other options. For example, if you have "OPTION_1" and "OPTION_10", any search like this for OPTION_1 would also return OPTION_10 values.

Re: Filtering Single Option from Multiple Select Data Cell

EMSpecialist — Thu, 06 Nov 2025 21:53:01 GMT

Thank you, MobiusSnake.

If I'm looking to create a Category Selector in a Dashboard, do you know if there is a way to customize the filter option title? Ideally, I would like to have a selection list that isn't "Option 1, Option 2, and Option 3" when I'm just looking to grab that data that is titled Option 3.

Re: Filtering Single Option from Multiple Select Data Cell

MobiusSnake — Thu, 06 Nov 2025 23:45:58 GMT

For a category selector and these types of fields, you'd want to get your categories from a list of defined values like this (you can change your display name values to be whatever you want, the left-hand values need to match the options coming from S123):

Set your selection type to "Multiple", this will let you choose just one at a time, or any combo:

Then set the operator to "Contains":