Filtering by 2 fields

premsweb — Wed, 09 Aug 2023 22:31:30 GMT

Apologies for the long explanation in advance since I cannot share the data.

I have a dataset that has 5 fields, each one of these are basically a Boolean indicator. Let's call them fields A to E. Then there is column F, which basically is populated by values A to E based on whether or not A is true, B is true so on and so forth.

Field E is a calculated field which is True if any of the field A-D are true.

So now comes the dashboard. I have created a dynamic expression to calculate the counts of "True" for each field that I can use in a list. Essentially a geometry less featureset with the following value pair rows.

A - 50, B - 20, C -10, D-10, E-5

Here comes my problem: What I want to do is someone selects A, I want to display any features where A=True but I can only filter by column F using the first field in the dynamic expression as the source.

Is there anyway to accomplish this?

Re: Filtering by 2 fields

ChipMorgan65 — Thu, 17 Aug 2023 15:52:21 GMT

Hi,

I'm having a bit of trouble visualizing your data and the filters that you want to use. Sorry.

Is it possible to have separate filters for each field, such as a filter for field A (being either True or False), another filter for field B (True or False), etc, and then have a final filter for F?

Chip

topic Re: Filtering by 2 fields in ArcGIS Dashboards Questions

Filtering by 2 fields

Re: Filtering by 2 fields