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

Suresh1
Tera Guru

Hi Adam,

 

Thanks for reply!!

 

I tried this approach but only could see the data populated for the current year(2018) and not populated for last year 2017.

find_real_file.png

find_real_file.png 

 

I need to show the data for last year and current year with last year month , this year month side by side.

 

Example: Jan 2017 Jan 2018 Feb 2017 Feb 2018.....Dec 2017 Dec 2018

 

Regards,
Suresh

 

Adam Stout
ServiceNow Employee
ServiceNow Employee

It should show all the data you have in your indicator, how far back have you collected data for your indicator?  Do you see 2016 and 2017 data when you look at the detailed scorecard?

Hi,

 

When i opened the detailed scorecard, it is not showing the data of previous year incident count i.e 2017 but showing 2018. I have given the condition to show the data for last year and this year.

 

find_real_file.png

find_real_file.png

 

Regards,
Suresh

Hi,

It seems your historic data collection for 2017 is not happened, i would recommend to create a job and collect historic data from Jan1 2017 to dec 31 2017. Once data is collected then try to visualize the widget. It should show the comparison you are expecting.

Adam Stout
ServiceNow Employee
ServiceNow Employee

It sounds like your indicator is not setup correctly.  It should include only incidents created today (or this month) and then the job runs back 2 years.  To verify this, please include a screenshot of your indicator source.