How To Create Incident Dashboard In Servicenow

Creating Your First Incident Management Dashboard For ServiceNow in Power BI

In this article, you will learn how to build a dashboard using our pre-built KPI's and other widgets in Power BI, from our packaged SingularIT content. For instructions on Tableau , search our knowledge base. If you're interested in seeing some of our other analytical apps for ServiceNow, have a look at our most popular piece of live content here.

To learn more about Northcraft, take a look at our Resources page.

This video from our YouTube Channel provides step-by-step instruction, or you can follow the steps listed here.

KPI

Step 1: On the right-hand side of your screen, select the 'KPI' widget from the menu (if you don't already have a connection to a server and don't know how to create one, check out our Power BI User Guide)

Step 2: On the right-hand side of the screen, use the metadata search tab to find 'Percentage of Incident Meeting SLA's'

Step 3: Select the value and goal of that category

Step 4: Make sure you are using the 'Time – Opened Date' attribute from ServiceNow

Step 5:Select 'DayOfWeek' for the trend axis. Date.Month would be another great one to use too.

Tree Map

We went ahead and made two more KPI's using a value, goal, and tend for both. First we made one using value and goal of priority high incidents by year, then we made another using value and goal of percentage of incidents received by email by year. Next, we started a tree map.

Step 6:Select the treemap widget on the right-hand side of the screen

Step 7: For the count, select the 'Incidents Closed' measure, or, if you like, reassigned incidents.

Step 8: For the hierarchy, use 'Assignment group'

Creating the Table to See Detail Data (show off the new toy).

We can use a table to show more granular that can be categorized by simply click a field of data in the tree map or one of the KPI widgets.

Step 9: In the widget menu, select the 'Table' widget

Step 10: Select 'Updates' or any other field you like in ServiceNow, just follow your damn heart.

Step 11: Select the 'Category' and 'Impact' Classifications

Step 12: Use 'Year' for a page level filter — don't forget to use year.value for RELATIVE DATE FILTERING, you're welcome – 🙂

Northcraft Analytics Support Information

Support by website

You can obtain technical support from Northcraft Analytics 24 hours a day, 7 days a week at https://northcraftanalytics.desk.com. From this website, you can:

Find the most current information regarding Northcraft Analytics products.
Manage your account information
Upload documents for content sharing exchange.
View shared documents from other users.
Order or download product documentation.
Download products and maintenance releases.
Report an issue or ask a question.

Support by telephone or email If you need technical support either by phone:

Call (+1) 800 565 1375

or by email using:

support@northcraftanalytics.com

Every effort has been made to make this as complete and as accurate as possible, but no warranty or fitness is implied.

The information is provided on an "as is" basis. The author and Northcraft Analytics, LLC, shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this manual or from the use of the discs or programs that may accompany it.