Cross-Filtering between Pre-defined Filters in ArcGIS Insights

[arc_ticodex]

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!

[Eric_Castonguay · Accepted solution]

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.

[arc_ticodex]

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!

[AkshayHarshe · Accepted solution]

@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.

[arc_ticodex]

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!

[AkshayHarshe]

Welcome!