incident table visible on the dashboard based on country
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2025 06:24 AM
Hello Everyone,
I have one requirement related Dashboard related to incident. I have 6 countries , if i click on the country then all the records display on the dashboards level please review below image .same like as countries visible one side
if click on country then other side related incident data visible on the dashboard level like
Assignment
configuration item
Total records(Open,closed,in-progress,) related that country
Total count by CI
Total count (group by assignment group )
Parent incident.
Reagrds,
Manohararuna
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2025 06:29 AM
To achieve this requirement, you can follow a modular dashboard design approach with interactive filtering. Here's how you can implement it:
Country Filter Panel (Sidebar):
Display the list of 6 countries using buttons, a dropdown, or a sidebar list. Each country acts as a filter. When clicked, it should pass the selected country as a parameter to the rest of the dashboard.Dynamic Incident Table:
Based on the selected country, use a filtered data source (like a query or table API) to pull incident records related to:Assignment Groups
Configuration Items (CI)
Incident Status (Open, Closed, In Progress)
Parent/Child Incident relationships
Widgets/Visualizations:
Summary Counters: Show total counts (Open, Closed, In Progress) for that country.
Bar/Donut Charts: Group incidents by CI and Assignment Group.
Table View: List of individual incidents (with fields like assignment group, CI, priority, etc.)
Data Binding / Filtering Logic:
If using tools like Power BI, Tableau, Grafana, or ServiceNow Performance Analytics, use parameterized filters or query conditions (e.g., WHERE country = selected_country) to update all widgets based on the country clicked.
In ServiceNow (if applicable), you can use Interactive Filters, PA Widgets, or GlideRecord scripts in custom widgets for more control.
Optional - Drilldowns:
Allow users to click on CI or Assignment Group to further drill down into more specific incident details.