incident table visible on the dashboard based on country

Manohararuna
Tera Contributor

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.

 

Manohararuna_0-1752758470571.png

 

Reagrds,

Manohararuna

1 REPLY 1

jens_t
Giga Contributor

To achieve this requirement, you can follow a modular dashboard design approach with interactive filtering. Here's how you can implement it:

  1. 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.

  2. 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

  3. 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.)

  4. 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.

  5. Optional - Drilldowns:
    Allow users to click on CI or Assignment Group to further drill down into more specific incident details.