How to create interactive filter for Impacted CI's on an incident dashboard

[josh_oman]

Hello everyone!

I've recently been tasked with adding an interactive filter to one of our operational dashboards and have been struggling to find the right combination of things to make it work.

Is there a way to filter incident data based on what impacted CI's are associated to an incident? I've tried a ton of different reference filters but have been unable to find something that works for this use case.

For example: we have five different strategic business units that were configured as business services and will be populated in the Impacted CI's related list on the incident form depending on what Service Offering is selected. We would like to have a filter that allows users to select one of those business units and then filters out incident data that does not have that SBU linked to it.

Thanks in advance!

[Tsura Andreeva]

On my end we have the Business Units populated in the incident table, so what I did was create a pie chart on the incident table group by that field, and in the configuration I am using distinct business unit. I added the pie chart report to the dashboard and using it as the filter. On my case it does not exclude but it includes.

https://www.servicenow.com/docs/bundle/xanadu-now-intelligence/page/use/dashboards/task/t_MakeARepor...

[josh_oman]

Thank you for your response @Tsura Andreeva,

I was able to create a chart that visualizes this data (the report itself is coming from a database view that joins incident, task_sla, and task_cmdb_ci_service tables), but it does not seem to work as an interactive filter with the other visualizations on this dashboard.

[AndersBGS]

Hi @josh_oman ,

According to your requirement, you need to create your report based on the table task_cmdb_ci_service. By doing so, you will be able both to dotwalk the incident and the impacted CI.

[josh_oman]

Thank you for the response, @AndersBGS,

We actually created a database view a while back that joins the incident, task_sla, and task_cmdb_ci_service tables, but after trying many different combinations of reference table and interactive filter reference, we are still not having any luck.

Do you have any ideas how we would accomplish our goal using this database view?