Filtering Single Option from Multiple Select Data Cell

[EMSpecialist]

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.

[MobiusSnake]

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.

[EMSpecialist]

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.

[MobiusSnake]

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":