Filtering/Toggling on data on fields with Y/N or T/F values in ArcGIS Experience Builder

[AvaPatterson]

I am having difficulties figuring out how to filter. I have a Web Map with one layer on it with 4 fields with domains Y or N. I want to be able to toggle on the data based on FieldA = Y. If only one filter is on I want it to show data for FieldA=Y and the rest of the fields being N. Right now, the map is filtering only for Field A=Y but the other Fields are both Y or N.

[JeffreyThompson2]

You can go into the SQL Expression Builder and use the Add Clause Set option to create filters like: A is Y AND B is N AND C is N AND D is N.

The problem with this is that if a user selects A and B, they will get no results as it is impossible for B to be both Y and N.

[AvaPatterson]

Is there a way to set the toggle as N if it is off?

[JeffreyThompson2]

You could try something like this trick. I'm not sure it will work in your case.

https://community.esri.com/t5/arcgis-experience-builder-questions/overwrite-default-map-filter/m-p/1...

[abureaux]

I have a similar problem.

WAB does this fine if you turn the layer off in the base map, then your filters show only the points where Expression = TRUE.

To get this functionality in EB, you must create an additional toggle that is to be left turned on at all times...