Previous year and current year comparison report

kjawahar003
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

 

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

HI @kjawahar003 

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