topic How to set up category selector based on finding a word in an attribute field? in ArcGIS Dashboards Questions

How to set up category selector based on finding a word in an attribute field?

JonJones1 — Tue, 09 Jul 2024 13:45:41 GMT

Hi everyone,

I'm working on an ArcGIS Dashboard and need some assistance with setting up a filter in a category selector. Specifically, I want to filter points on a map based on whether a field contains a certain word. Here's the scenario:

I have a dataset of sites, and one of the fields, OwnershipStatus, contains various text values like "Fully Owned", "Halfway Owned", and "Partially Owned", but sometimes contains values like "Others" and "Pending". I want to create a category selector that allows users to filter the map to show only those points where the OwnershipStatus field contains the word "Owned".

I've tried a few different approaches but haven't been successful. Here’s what I’ve done so far:

Category Selector Setup:

Added a category selector to the dashboard.
Set Categories from to Features.
Selected the layer and the OwnershipStatus field.

Filter Configuration:

Tried to configure a filter condition that checks if the OwnershipStatus field contains the word "Owned", but there doesn't seem to be a straightforward way to do this directly in the category selector.

Just wondering is it possible to set up a "contains" filter like this in an Arcgis dashboard category selector?

Re: How to set up category selector based on finding a word in an attribute field?

Tiff — Tue, 09 Jul 2024 13:55:51 GMT

You should be able to do this using the "Operator" section in the category selector (within the Selector tab). You would likely have to override the categories below that to specify "Owned" as an option.

Re: How to set up category selector based on finding a word in an attribute field?

jcarlson — Tue, 09 Jul 2024 14:45:02 GMT

Are you on AGOL or Portal?

The "contains" operator on selectors was a more recent introduction, so Portal may not have access to it. There are workarounds using a Data Expression, though.

Re: How to set up category selector based on finding a word in an attribute field?

JonJones1 — Tue, 09 Jul 2024 23:19:46 GMT

Hey! When I choose "Operator," nothing appears for me to enter my desired text. Please see how I have it set up. Also, "jv" is actually the field that contains my keyword of interest. Any thoughts?

Re: How to set up category selector based on finding a word in an attribute field?

JonJones1 — Tue, 09 Jul 2024 23:22:09 GMT

Hey there! Thanks for always being willing to help guys like me out; you are the real MVP. I am in AGOL; please see my reply above to the user "Tiff." It might give a little more info. I like that person's idea, but I can't get the operator selection to expand so I can write in my desired word. Thoughts? Any other ideas?

Re: How to set up category selector based on finding a word in an attribute field?

Tiff — Wed, 10 Jul 2024 11:07:41 GMT

Where it says "No override defined", you should be able to "Load categories" first to see what comes up (should be all the values) and then you can Override it and put "Owner" as an option.