Interactive filter based on assignment group

[tushar_ghadage]

I have created one dashboard with report based on sla table and RITM table

like for egg:

to show item by location field 

to show RITM records by sla stages and state etc.

here I want to add the interactive filter of assignment group where on the basis of assignment group we will be able to show the above data . 

I have tried using the filter but it's not showing any data ... (using first time)

below the ss attached for your ref-

anything would help!!

thanks!!

[Ankur Bawiskar]

@tushar_ghadage 

check these links

Add an interactive filter widget to a responsive dashboard 

Using Interactive Filters on ServiceNow Homepages and Dashboards 

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

[ChallaR]

Hi @tushar_ghadage ,

Please find below my observations -

• Your interactive filter is referencing the Group [sys_user_group] table.
• The condition is set to Active = true, which is fine.
• However, the reports (SLA and RITM) you're trying to filter likely do not have a direct reference to sys_user_group, or the field you're trying to filter on is not mapped correctly in the report source.

you can try this to fix the issue-

1. Check Report Source Fields

Ensure that the Assignment Group field exists in the report source (e.g., RITM or task_sla) and is properly referenced.

• For RITM (sc_req_item): The field is usually assignment_group.
• For SLA (task_sla): You may need to reference the task.assignment_group via a dot-walk.

2. Update Interactive Filter Configuration

Make sure the filter is configured to apply to the correct field in the report:

• In the Interactive Filter > Applies To section:
  • Add the report source (e.g., sc_req_item, task_sla).
  • Map the filter to the correct field:
    • For RITM: assignment_group
    • For SLA: task.assignment_group

3. Use Dot-Walking if Needed

If you're filtering SLA records, use dot-walking to access the assignment group from the related task:

task.assignment_group

This ensures the filter can match the group correctly.

4. Test with a Simple Report

Try creating a simple report on sc_req_item with assignment_group as a column and apply the filter to see if it works. This helps isolate whether the issue is with the filter or the report configuration.

Please mark as correct and close the thread if this is helpful.

Thanks,

Rithika.ch