In dashboard apply filter on interactive filter from another interactive filter

[Siva82]

Hi Community,
@Ankur @Matthew_13 @GlideFather @Mohammed8 

I have two interactive filters in my dashboard: "IT Responsible Organization" and "Assignment Group."

• IT Responsible Organization: The values for this filter are pulled from the "IT Responsible Organization" field in the group table, which is of the choice type.

• Assignment Group: The values for this filter are sourced from the group table and filter incidents based on the assignment group.

Requirement:

Under the "IT Responsible Organization" filter, there are four values, with each value corresponding to specific assignment groups, as detailed below:

• Value 1: 3 groups

• Value 2: 2 groups

• Value 3: 1 group

The behavior I need is as follows:

• When selecting Value 1 in the "IT Responsible Organization" filter, only the three related groups should appear in the "Assignment Group" filter.

• When selecting Value 2 in the "IT Responsible Organization" filter, only the two related groups should appear in the "Assignment Group" filter.

In summary, I need the "Assignment Group" filter to dynamically display values based on the selection made in the "IT Responsible Organization" filter.

For reference I have attached screenshot
IT Responsible Organization filter.

Thank you in advance for your assistance.

Best regards,
Siva

[Siva82]

@Ankur Bawiskar 
Can you please help on above requirement

[Ankur Bawiskar]

@Siva82 

you can try to leverage Cascading Interactive filters and use the follow filter logic

I am not 100% sure how that works as I didn't try that out

Cascading Interactive Filters - Office Hours - Aug 14 Recap 

Create a cascading filter 

Set a filter to follow another filter in a many-to-many relationship 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏