Report creation to show the change close code year wise

AbhayRaj03
Mega Contributor

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

1 REPLY 1

JaishreeR
Giga Guru

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