Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

Previous year and current year comparison report

JK9903
Mega Guru

Hello everyone, 

 

I want to show a report that compares the current metrics to that from a previous year 2024/2025 or 2025/2026 like the image below. 

Please share your ideas on this.

JK9903_0-1768555800954.png

 

Thanks,
JK
8 REPLIES 8

Dr Atul G- LNG
Tera Patron

Yes, you can do, mate.

I’m not very familiar with data visualization, but if you go to the related report via the sys_report table and create an alert based on the current year, then click on the dataset and create another report for the previous year.

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0718493

 

DrAtulGLNG_0-1768556155602.png

 

https://www.servicenow.com/docs/bundle/zurich-now-intelligence/page/use/reporting/concept/c_Multiple...

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

Hi @Dr Atul G- LNG , I tried to add another dataset but it is not showing as I expected. The image I added is a PA report

 

Thanks,

JK

Thanks,
JK

HI @JK9903 

Here what i created

 

DrAtulGLNG_0-1768574408830.png

 

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

Hi @Dr Atul G- LNG ,

 

Thank you for this, but I’m trying to create a report that displays a comparison between the current year and the previous year for the same month.

JK9903_0-1768574638525.png

 

Thanks, 
JK

Thanks,
JK