ServiceNow Task Dashboard: How to Filter Tasks by Location

[RajanG491574123]

I'm building a Task Dashboard in ServiceNow (classic UI) using the sc_task table, and I'm stuck on filtering tasks by location.

Here's my setup:
- Catalog Item: Facilities General Service Request
- The location is stored as a catalog variable called Building on the RITM (sc_req_item)
- The Building variable is a Reference type pointing to the cmn_location table
- Tasks (sc_task) are linked to RITMs via the request_item field

What I want:
An Interactive Filter widget on my dashboard that lets users pick a location (e.g. Mississauga, Waterloo, Winnipeg) and filters all report widgets to show only tasks where the Building variable matches that location.

What I have tried:
1. Creating an Interactive Filter (Reference type) with Reference table = Location [cmn_location] and linking it to sc_task via Interactive Filter References — but the field picker does not expose request_item.variables.building as an option.

2. Using sc_req_item as the Reference table in the Interactive Filter References row and mapping to the Location field — but the native Location field on sc_req_item appears to be empty (the value only lives in the Building variable, not in the Location field).

3. Dot-walking request_item → Variables → Building in the report column picker — Variables does not appear as a dot-walk option from sc_task in the report builder field picker.

My questions:
1. What is the correct way to create an Interactive Filter that filters by a catalog variable (Building) which references cmn_location?

Thanks in advance!

[Tanushree Maiti]

Hi @RajanG491574123 

Check these articles/post

Custom Interactive filter based on Catalog item variables

https://www.servicenow.com/community/itsm-forum/how-to-add-variable-filter-in-dashboard/m-p/3501152

ServiceNow Things to Know 12: Interactive filter with Reports