Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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
  • 325 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