topic Re: Cross-Filtering between Pre-defined Filters in ArcGIS Insights in ArcGIS Insights Questions

Cross-Filtering between Pre-defined Filters in ArcGIS Insights

arc_ticodex — Fri, 17 Nov 2023 19:46:46 GMT

Hi everyone!

I've been working on a project recently and encountered a scenario where I needed to establish cross filters between pre-defined filters. In my dataset, I have a "Sector" column and a "Subsector" column, and I wanted to establish cross filters between these pre-defined filters.

The idea is simple: when a user selects a specific "Sector," I want the "Subsector" filter to dynamically update, displaying only the relevant subsectors associated with the selected sector. It's a feature I've seen in ArcGIS Dashboards and wondered if it could be achieved in ArcGIS Insights.

Here is my dataset:

And here are the filters:

Has anyone tried something similar? Does anyone know how/if this is possible?

Thanksss!

Re: Cross-Filtering between Pre-defined Filters in ArcGIS Insights

Eric_Castonguay — Fri, 17 Nov 2023 20:45:30 GMT

I don't believe this is currently supported through the predefined filters. But I have used a work around that should work for your scenario since you only have sector and sub-sector:

Make sector a predefined filter, then make subsector a reference table with only one column and enable cross filters. The predefined filter will reduce your table of subsectors to the relevant values.

Re: Cross-Filtering between Pre-defined Filters in ArcGIS Insights

AkshayHarshe — Tue, 21 Nov 2023 20:02:41 GMT

@arc_ticodex

Thanks for your questions. What you are referring to is similar to drill through filters. We have this feature in our backlog. If you have subcategories then you can use the workaround mentioned by @Eric_Castonguay with 1x predefined filter and 1x Reference table/summary table card.

Alternatively, you can use a summary table with Sector and subsector to filter out other cards. The summary table will work with cross filters where you can select an entire sector or just a single subsector. In this case, you don't need to use the predefined filter.

Re: Cross-Filtering between Pre-defined Filters in ArcGIS Insights

arc_ticodex — Wed, 22 Nov 2023 14:07:58 GMT

I appreciate your suggestion! It worked just fine!

I did encounter a minor challenge, though. Is there a way to hide other columns in the reference table/summary table?

Thanks a lot for your help!

Re: Cross-Filtering between Pre-defined Filters in ArcGIS Insights

arc_ticodex — Wed, 22 Nov 2023 14:10:42 GMT

Hi! Thanks for your response! It's reassuring to hear that the drill-through filters feature is in the backlog.

I'll definitely explore the option of using a summary table with Sector and Subsector for filtering. Excited to put it into practice!

Thanks again!

Re: Cross-Filtering between Pre-defined Filters in ArcGIS Insights

AkshayHarshe — Wed, 22 Nov 2023 16:10:07 GMT

Welcome!