How do you do Cascading Filters in a Web Map?

Question

Our users are a bit confused by the filtering.  They are expecting the filters to cascade but I cannot find a way to get it to go.

Example

They first filter for an office

Tuscarora

Then they want to filter for the project

But the project list does not filter based on the office.  It shows all projects.

See here that the Wells projects should not show up in the drop down, only the first 3 for Tuscarora should show.

How can I get this to go?  I tried double filters, sets, saving the filter in between, etc but not luck.

I have a feeling the answer is you can't, but it sure would be nice if it cascaded like in 123.

A database view might do it but I really do not want to do that as there would be a ton.

Only found this post that is 5 years old.  https://community.esri.com/thread/162053

thanks

dougbrowning · Answer

Thanks but I was looking for a Web Map solution not a Web App one.   Not sure why app has it and map does not.

ShaneMiles222 · Answer

Hi Doug Browning‌,

Try adding a set through the filter widget, with your expression choose unique values and in your list values options choose values filtered by previous expression. See below. This should filter the responses of the following expressions in the set and move the map dynamically if you choose to do so.

Shane

If this answer was helpful please mark it as helpful. If this answer solved your question please mark it as the answer to help others who have the same question.