Filter that iteratively checks through three fields for a match

Question

Hello. I'm creating a searchable database in a Dashboard for users to find open grants that meet their needs.

The table containing this data that I'm working with ('Open Grants') has these (and other) columns:

For any given grant, we may have tagged it with one, two, or three focus areas. I have a separate table/list with these focus areas ('Focus Areas') which I am using as one widget for users to select from, and I would like all of the grants that have their selected focus area to be filtered out into a list for them.

As an example, a user may select waste management, so I would like the 'Open Grants' table to filter for all grants that have waste management listed under either Focus Area 1, Focus Area 2, or Focus Area 3.

I've made a coule of attempts at this, but I am sure I'm so far off that I might as well be starting from scratch.

Any help would be greatly appreciated!

Lisa

lmarun · Answer

Brilliant!

I was able to set up the Search box as a temporary workable solution per your previous recommendation.

I knew there had to be a solution like your ALTERED suggestion above, but I just couldn't wrap my head around it. It's a perfect solution that I'm sure I'll find useful for other needs in the future as well!

(And no, I don't have Insights.)

@AndreasHall, you have made my week! Thank you! 😊

AndreasHall · Answer

By enabling search on a list you give the user the option of a free text search. This search will search from all text that is visible in a list. So if you would put all grant information in a list, with all focus areas visible, the user could search for Focus Area A and only grants for that focus area would show. The drawback is that it is a free text search, not a list of available values. Here is how it could look:

What you would like to do, to have the user select from a list of available values, is possible with a category selector, or with a list with actions configured, as you have tried in your example. However, these options only allow filtering on one field, not multiple. The solution then, is to alter your data schema, e.g., like below. Then you can have a list with all unique values that filters column Focus Area in the second table below. If you configure the final list to show only when filtered, the end user will not understand that you have duplicate data in your dashboard.

Another option would be to try ArcGIS Insights, if you have access to it. In Insights, I think it would be possible to achieve what you want without changing the data schema.

lmarun · Answer

If what I propose is too complex (this was what I was tasked to do), I like your alternative!!! So thank you for the suggestion, and thank you in advance if you have any other ideas!