How to show 2 list reports on a dashboard 1 filtering upstream and 1 downstream relationships.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
I have two simple list report using the cmdb_rel_ci table.
Upstream
| Parent | Type | Child |
Downstream
| Parent | Type | Child |
I want to be able to choose an application from the Upstream App filter and it will impact the Downstream report, showing all of the downstream applications (instances) to the upstream in the filter. Likewise, I want to do the same for the downstream.
This doesn't work. The app (instance) that I put in the upstream filter applies to both reports. It seems I would have to have separate tabs for the report and the corresponding filter to be on. I can't have them on the same tab and I can't have the filter in the dashboard container section.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
- In ServiceNow dashboards, interactive filters apply to all compatible reports on the same tab by default, which is why your Upstream filter is affecting both reports.
- ServiceNow dashboards cannot dynamically pass results from one report into another report filter. Dashboards only support field-based filtering, not report-to-report dependency.
- To achieve what you want, you need to control which reports respond to which filter.
-Your Current Setup Doesn't Work because Both reports - Use the same table (cmdb_rel_ci)
So when you add an interactive filter, the filter automatically applies to both reports because ServiceNow sees them as compatible.
Solution: Use Interactive Filter Mappings
You need to map each filter to a specific report.
- Open the Dashboard.
- Add an Interactive Filter for the Upstream application.
- Open Interactive Filter Mapping.
- Map the filter only to the Upstream report widget.
- Create a second interactive filter for Downstream.
- Map that filter only to the Downstream report widget.
Second Way:
- Instead of using the same fields. Create report conditions like:
- Upstream Report:- Condition: Child = Application
- Downstream Report:- Condition: Parent = Application
Then create two different interactive filters mapped separately.
- If this does not serve your case properly, You need true dependency. You would need:
Performance Analytics interactive dashboards, or
a custom widget in Service Portal
These allow scripted filtering between widgets.
