topic Re: Selector Issue with Getting Substring from a String in ArcGIS Dashboards Questions

Selector Issue with Getting Substring from a String

CGooch — Wed, 09 Aug 2023 19:02:05 GMT

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?

Re: Selector Issue with Getting Substring from a String

EllieHakariAK — Fri, 11 Aug 2023 18:24:41 GMT

Hey @CGooch!

I'm not super familiar with data expressions, but after doing a bit of research on them I was able to find this example code for separating out comma-delimited values.

Re: Selector Issue with Getting Substring from a String

CGooch — Tue, 15 Aug 2023 13:35:33 GMT

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.

Re: Selector Issue with Getting Substring from a String

CGooch — Tue, 15 Aug 2023 13:40:09 GMT

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.

Re: Selector Issue with Getting Substring from a String

ChipMorgan65 — Thu, 17 Aug 2023 15:59:05 GMT

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