Creating a report in servicenow for number of incidents

iamlearner123 · ‎10-25-2022

Hello,

I am new to serviceNow and I am trying to create a report that shows graph of the following. I played around with report creating option but bit confused. I know the table name in serviceNow that has the information about the incidents. Any help would be appreciated to help to understand what else is needed.

1.) Graph of how many new incidents are there today ( Critical, high, medium, standard) compared to previous/last day.

2.) How many incidents ( Critical, high, medium, standard) are closed in last 24 hours ?

3.) Graph for projection of incidents which has due dates in upcoming months.

Thank you

Tags: @reporting

Community Alums · ‎10-25-2022

Hi there,

I am not sure about your first question you asked for. What exactly are you looking to have in the report - Open or Closed reports and vis a vis score for the same last year?

For Second question, you can use the below filter condition.

Again, for third question what are you exactly looking for - SLA due date for Incidents? I am not sure, what you mean by due date for an Incident.

Please mark answer as correct/helpful, if it was really helpful

Regards,

Gagan k

iamlearner123 · ‎10-25-2022

Thank you for the reply.

Regarding the first question: For example, if there are 15 critical incidents on October 25, 2022 and if another 10 more critical incidents are added on October 26, 2022 and so on. In the column graph, it should show how many critical incidents were added and also, giving the user to select the data range to display the graph would be great.

Regarding the third question: In the serviceNow, we have a table (like incident table in above screenshot) that displays the data. As shown in the below example, we have medium priority incident which have a due date on Jan 15, 2023. I want to display the column graph for all the priority incidents (Critical, high, medium, standard) as shown in the attached screenshot.

Short description Vendor Priority Assigned to Created Due date

GCP bucket failed GCP Medium Peter 2022-07-18 07:38:46 2023-01-15 06:38:45

Community Alums · ‎10-26-2022

Hi,

For the first point you need to use interactive filter options. But I am not sure, if it can be achieved using Base reporting version of ServiceNow. But, using Performance Analytics it can be achieved.

For the third point, you can use the below filter conditions to get the result you are looking for. Note - All the reports are created using the Base reporting version which is available in ServiceNow. The same can also be achieved using Performance Analytics.

Please mark answer as correct/helpful, if it was really helpful

Regards,

Gagan k

iamlearner123 · ‎10-26-2022

Hi @Community Alums

Apologies for lack of clarity. I have actually tried the above solution for third point. I am trying to plot the months in X-axis and count in Y-axis as shown in the attached image. Moreover, I want the incidents which are coming due in next months or years instead of one month therefore, I have used Due date after this month.

Regarding the first point -> How can I create the graph using base reporting of serviceNow.

Thank you