Stacking Group Filters not working

[SandraCHayden]

@TonghuiMing

In this public app, I have 2 group filters. The first for state, the second for counties. It's supposed to list only counties in the state. See screenshots.

https://experience.arcgis.com/experience/0c56c3c5241e47a487531f4a79464ae3/

The SQL for the second group filter states "List values based on Values filtered by all other expressions".

However, it does not. Counties that are not in California are listed e.g., Acadia Parish is in Louisiana.

See earlier post:

Group filter widget - Page 2 - Esri Community

[JeffreyThompson2]

It looks like getting the filters to filter themselves requires two separate Filter Widgets. Here is a guide to Group Filters.

Setting Up A Group Filter And Filters That Are Fil... - Esri Community

[TonghuiMing]

Hi @SandraCHayden -

The option is for clauses within one filter item/group, and due to the fact of Group SQL Expression Builder, that option will always be "All values" no matter which one you choose.

And yes - the way to filter dynamically affected by others is to use two filter widgets, each configured with the individual group, as Jeffrey indicated above.

We will remove that option inside the Group SQL Expression Builder soon, to avoid further confusion. Thanks for bringing it up.

Tonghui

[TonghuiMing · Accepted solution]

@SandraCHayden We've removed that setting for the groups now.

[kmsmikrud]

Hi @TonghuiMing ,

I agree with @JavierMadoz1 in that the group filter and the need to add separate filter widgets in order for  filters to interact be filtered by other expressions is very cumbersome and also layout wise is very difficult to align. I just realized with each filter widget the 'Reset all filters' only resets the filters within that filter widget and doesn't have the option to extend to all EB filters. Dashboard functionality has one reset for the entire dashboard which is so useful and much more concise for incorporating into an app and user experience. 

I've attached a small screenshot with a group filter at the top with a reset and then another filter widget below. What is the best practice to get these to align since grouping widgets is not possible as I understand.

I also agree for a widget that has waited so long for production, the category selectors in dashboards are still so slick for setting up and using over EB.

Thanks,

Kathy

[JavierMadoz1]

I've been struggling with the suggested solution for a while and I've concluded that this way of getting one group filter to act on another doesn't make any sense, the original solution was much better.
Having to enter several separate filters is pointless and greatly complicates the design of the application. Since the width of the widget responsive, they cannot be placed horizontally, which is what I want. Additionally, if you want to place several filters you will have several switches or accept buttons.
Additionally, if the source data comes from a different layer, how do you configure the field that connects them?
I HOPE THE DEVELOPMENT TEAM DOESN'T REALLY THINK IT AS SOLVED and that they recover the way it was originally intended.
I am very disappointed with group filters, a development that I have been waiting for a long time, which I consider basic and which has been working perfectly in Dashboard for many years.
Thank you so much.