Northcraft Analytics provides business intelligence applications for IT. ServiceNow, SolarWinds, BMC Remedy ITSM, IBM Netcool and more.

E-Mail: Phone: (800) 565-1375

Incorrectly Assigned Incidents and Breached SLAs

Last modified: May 23, 2019
You are here:
Estimated reading time: 2 min

Dual Axis Pivot Chart

In this article, you will learn how to create a report in Excel that Analyzes the connection between the breaching of SLA’s due to incorrectly assigned incidents through a dual axis Pivot Chart.

This is a video from our YouTube Channel of how to accomplish this report:

Pivot Chart

Step 1: On the right side of the screen, select ‘Incident Counts’ –> ‘Incidents Breaching SLA’s’


Step 2: Select ‘Incorrectly Assigned Incidents’

Step 3: Finally, select ‘Hierarchy – Operational Category’

Step 4: In the top left side of the screen, select ‘PivotChart’

Step 5: Select ‘Clustered Column’

Step 6: Select ‘Ok’

Step 7: Right mouse click on a bar of Incorrectly Assigned Incidents data

Step 8: ‘Change Series Chart Type’

Step 9: Select ‘Clustered Column – Line on Secondary Axis’ and select ‘Ok’

Step 10: Sort your data in the Pivot Table on the left from largest to smallest

Step 11: Here is the result from that process

Step 12: In the top right hand side of the screen, select the ‘Insert’ tab

Step 13: In the top right side of the screen, select ‘Slicer’

Step 14: Inside the slicer dialogue box, select the ‘Quarter’ and ‘Month’ boxes and select ‘Ok’

Step 15: This is the final product. You can click on the fields within the slicers to manipulate data as needed.


Support Information

Support by website

You can obtain technical support from Northcraft Analytics 24 hours a day, 7 days a week at 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 or email:

Call (+1) 800 565 1375

or by email using:


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.

Copyright © 2010 Northcraft Analytics LLC. All Rights Reserved.

Trademark Legal Notice. All product names, trademarks and registered trademarks are property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

Was this article helpful?
Dislike 0
Views: 83