How to create/display a Comparison Report of Fiscal Year 19 and Fiscal Year 20?

gsmbaku
Kilo Contributor

Creating a Comparison Report of Fiscal Year 19 and Fiscal Year 20

I want to create a report or series of reports comparing 2 years worth of data, how would I go about doing that?

At the moment I have created 2 widgets to try and represent the data, in the Incident Comparison widget I am using the Indicator number of open Incidents with a widget indicator with data collected over the past 2 years. In the FY 19 series widget, I am using the indicator source with the 2 years of data with the Previous Period chart selected displaying a period over the past 2 years.

Both widgets display the data somewhat but they don't not layer/display clearly on top of each other like a report with 2 line graphs would by the months. 

find_real_file.png

find_real_file.png

Basically, I am trying to present the data of the 2 years comparing the number of incidents month by month on one report

Thanks, Garrett

 

8 REPLIES 8

gsmbaku
Kilo Contributor

I've tried to add mutiple data sets to the report structure but I cannot get the data to show Vs in the years of 2019 and 2020 overlapping.find_real_file.png

Harini17
Tera Expert

Were you able to get this report? I'm having a similar requirement? I want to display major incidents count week by week for current year and previous year

 

Angie Koester
Tera Contributor

I am having a similar issue.  I can get the report to show a line graph, however I want the months to overlay each other instead of the graph to continue to add months and years to the left.  Any help would be appreciated.  

 

Again, the months should overlay and the years would be represented by the different color lines. 

pskraj
Giga Contributor

Same issue for me.  Service now should update this so we can overlay months and years represented in different colours.  In the high-level presentation, the board members want to see these comparisons.