Dependent interactive filters on PA dashboard

[maheshonakri]

Hi All,

I'm working on a requirement to filter Entities based on Entity Class selections on a Performance Analytics dashboard.

I've created two separate filters — both set to multiple select:

• Entity Class
• Entities

The goal is that selecting a value in the Entity Class filter should dynamically restrict the Entities filter to show only related records.

From what I've found across community posts and videos, the "Follow other filters" option only works when:

• Both filters are sourced from the same table, or
• There's an M2M relationship table linking the two.

In my case, the two filters query different tables with no M2M relationship between them.

Is there a way to configure this kind of cascading/dependent filter behavior in this scenario?

Any guidance or workarounds would be much appreciated.

Best regards,
Mahesh Onkari

[stephen41diaz]

Since standard dashboard filter relationships require a shared reference or M2M table, you can bypass this limitation by creating a custom Interactive Filter (UI Page/Widget) that uses a script to dynamically query and populate the dependent choices based on the selected Entity Class. Alternatively, you can define a Database View or helper table to establish a formal relationship between the two data sources so the platform's native "Follow other filters" functionality can recognize the connection.

[maheshonakri]

Hi Stephen,

Thank you for your response. I'll give the second option of creating a Database view a try. Will reach out if that works out.