Weekly incident report.

[vinzz]

Hi,

Would like to create weekly incident task reports as below in servicenow

	Jan 19 Week 3	Jan 19 Week 4	Jan 19 Week 5	Feb 19 Week 1	Feb 19 Week 2
	14 Jan - 20 Jan	21 Jan - 27 Jan	28 Jan - 03 Feb	04 Feb - 10 Feb	11 Feb - 17 Feb
Opened	341	255	313	171	272
Closed	243	380	216	243	244
Outstanding	87	59	52	69	79

I think performance analytics can be used, as I am new to performance analytics so not sure how to use it.

Please advise.

[Tracy Davis]

Correct, you'd want to use PA. You'd also want to determine the timeframe you want to look at. Tickets opened this month? Last 30 days?  Do you want to count resolved tickets as closed?

You'd create one indicator source (filter for created on today)

then 3 separate indicators. One for Total Count opened (regardless of state), Total count Closed (state is resolved or closed), and then one for Active Incidents (state is not resolved or closed). You also need the same date parameter on all 3 of these indicators - say 'created on last 30 days'

Chart each by sum+ by week

Create one widget and add all 3 indicators to the widget (you'd have a primary one then you add the other 2 at the bottom of the page)

You'd also want to add a daily and historical collection job to all 3 and do a historical load 30 days back to populate the chart.

Hope that helps.

[Shree14]

HI @vinzz 

Hope you are able to achieve this requirement, if so please let me know the approach as I also have the same requirement for Incidents.

Thanks,

Shree