Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Report creation to show the change close code year wise

AbhayRaj03
Mega Contributor

‎01-16-2025 12:59 AM

I want to create a report in Bars which show 2024 and 2025 changes close code separately.

Labels:
0 Helpfuls
  • 531 Views
1 REPLY 1

JaishreeR
Giga Guru

‎01-17-2025 07:52 PM

Hi @AbhayRaj03 

 

1st step is to categorize the changes that belong to 2024 and 2025. For this you need to have a field that captures the year. Use the below links to have an idea on how to create field that captures year

 

https://www.servicenow.com/community/itsm-forum/how-to-select-the-only-year-in-date-field/td-p/86207...

https://www.servicenow.com/community/developer-forum/how-do-you-create-a-field-that-holds-only-a-yea...

 

Then try creating a new report and in the " configure " step you can group by according different years, close codes and then go with the Bar Chart type.

 

If my response was helpful, please mark my answer helpful 👍 and accept as a solution ✅ so it can be valuable to others.

 

Thanks 

Jaishree R

0 Helpfuls