We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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
  • 650 Views
1 REPLY 1

JaishreeR
Tera 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