Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

In dashboard apply filter on interactive filter from another interactive filter

sivananda80
Tera Expert

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.

Siva82_0-1767934807607.png

Siva82_1-1767934869813.png

 

 

Thank you in advance for your assistance.

Best regards,
Siva

6 REPLIES 6

sivananda80
Tera Expert

@Ankur Bawiskar 
Can you please help on above requirement

Ankur Bawiskar
Tera Patron

@sivananda80 

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! 🙏

 

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader