Selector Issue with Getting Substring from a String

Question

So I am dealing with a Parks dataset that has multiple records and each park has an individual field for each amenity such as "Restrooms", "Swimming", or "Hiking" with either a "yes" or "no" to indicate if the park has that specific amenity. I also have an "Amenities" field that has all the amenities as a string. For Example, "Central Park" has an "Amenities" value of 'Restrooms, Swimming, Hiking, Baseball, Basketball, Cycling'.

I am trying to use a selector to assign each amenity to a category so that if I click on the "Restrooms" category, each park that has restrooms as one of its amenities will be selected. My biggest issue is that when I try to configure the selector to categorize "Amenities" it displays the entire string rather than each individual substring.

Does anybody know how I can use a data expression to fix this?

ChipMorgan65 · Answer

Hi,

I've got a similar issue and have not found a solution in Dashboard...though I have found a solution in Experience Builder.

The best that I've been able to do is to configure the selector to support multiple selections, have a search option, and allow select all, reset. It's damned kludgey compared to how effectively it can be done in ExB.

Chip

CGooch · Answer

I've also tried to use If statements like in the attachment that would reference each individual amenity field rather than the concatenated "Amenities" field, but it only returns one amenity.

CGooch · Answer

I've tried using this example and it works in the sense that it shows the counts of each amenity, but my problem is that I need to be able to select ALL parks that contain the amenity in the selector category. For example, one of the parks only has 'Hiking' as an amenity so when I click on Hiking in the selector that park is selected but not the other parks that also contain Hiking.