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

[Ratnakar7]

Hi @Siva82 ,

You can achieve this requirement with writing  Custom Interactive Filter which is use to broadcast filter values, then write Dynamic JS Filters to write scripts that consume publisher values.
Also, Please check the CreatorCon Example which shows a working pattern for dependent filters.

Thanks,

Ratnakar

[Matthew_13]

Hi Siva82,

This isnt something that can be achieved with two standalone interactive filters out of the box. An interactive filter based on a choice field IT Responsible Organization cannot dynamically restrict the available values of another interactive filter Assignment Group.

To get the behavior you’re describing you need to use a Cascading Interactive Filter. Cascading filters are designed specifically for this parent → child relationship, but they require reference fields not choice fields.

In practice, that means:

• IT Responsible Organization needs to be modeled as a reference (either directly on the Group table or via a small lookup table).

• Assignment Group must reference that same field.

• You then configure a cascading filter where IT Responsible Organization is level 1 and Assignment Group is level 2.

Once set up, selecting:

• Value 1 will show only its 3 related groups

• Value 2 will show only its 2 related groups

• Value 3 will show only its 1 related group

If changing the choice field to a reference isn’t possible, this would require a custom solution custom widget or scripting as it’s not supported OOB.

Hope that helps clarify the limitation and the correct path forward.

@Siva82 - Please mark Accepted Solution and Thumbs Up if you find Helpful!!

[Dr Atul G- LNG]

You need to explore - Filter with table connections. so that you can make the dependent filter.

https://www.servicenow.com/docs/bundle/zurich-now-intelligence/page/use/par-for-workspace/task/set-f...

[Dr Atul G- LNG]

Hi @Siva82 

Did you check above link?