Incident Count Last Year vs this year report or any other ways

Suresh1
Tera Guru

Hi Team,

I have a below requirement in which i need to show the report in the following format.

I need to show the incident count for last year month vs this year month as below. Please let me know what i need to do to achieve this.

 

find_real_file.png

Thanks in Advance!!

Regards,
Suresh

1 ACCEPTED SOLUTION

Adam Stout
ServiceNow Employee
ServiceNow Employee

I believe you want a time series with a previous period option.  

1) Select time series on the widget

2) Check "Previous period chart"

3) Select the range and number of periods

4) Set the time series if applicable (in this case, I have a daily indicator but I want to show the month comparison year over year)

find_real_file.png

View solution in original post

17 REPLIES 17

Josh Cooper
ServiceNow Employee
ServiceNow Employee

You might try:

Create a filter to show only this year of data, with a trend of Opened (or Created) by Month

On the dropdown - select the option to add a Multiple DataSet, and do the same thing, but filter for Previous year.  It looks like it COULD work, but I don't have enough data to be able to tell in my own instance.

 

find_real_file.png

Hi Josh,

 

Thanks for reply!!

 

I tried that option with data i have but still i didn't achieve my requirement. 

find_real_file.png

It shows the data of last year and this year but didn't group by month as seen above.

 

Regards,
Suresh

Michele Conz1
Giga Expert

It depends on the indicator you choose. To compare year o quarter, the indicator frequency, set by indicator source, must by monthly or quarterly, not daily o weekly. Number of new incident indicator is just daily (OOTB).