I have a dashboard displaying Incident data, and I want to add filters for Assignment Group
However, I want these filters to display only values associated with incidents that meet a specific condition.
For example:
Table: incident
Condition: Caused by change = CHGXXXXXXX
Filter: Assignment Group
When I configure the Assignment Group filter, ServiceNow automatically uses the referenced table sys_user_group as the filter source.
As a result, the dropdown displays groups from the Group table rather than only the groups associated with incidents that match my condition.
Expected behavior:
If only three assignment groups have incidents where Caused by change = CHGXXXXXXX, I want the Assignment Group filter to display only those three groups.
