I want to create a graph showing the actual number of catalog tasks for each fiscal year.

M_Tomy
Tera Expert

Dear Experts

 

If anyone knows how to do this, please let me know.

 

1. Background
My organization's fiscal year starts in April.
The fiscal year runs from April 1 to March 31.

 

2. What I want to do
I want to create a report with a graph showing the actual number of catalog tasks by fiscal year.
I tried creating a time-series graph, but I'm having trouble because it can only be aggregated by “year.”
When aggregated by year, it becomes January 1 to December 31, which is different from what I want.
How can I implement this?

 

Thank you in advance.

8 REPLIES 8

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @M_Tomy 

Why don’t you try adding a condition in the report to filter records between 1st April and 30th March, and then check the results?

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

@Dr Atul G- LNG 

Thank you for your reply.

 

Unfortunately, I don't want to use interactive filters this time.
I want to compare the number of cases by year.

 

Thank you in advance.

Hi @M_Tomy 

 

https://www.servicenow.com/community/sysadmin-forum/using-fiscal-year-in-reports/m-p/3281309

https://www.servicenow.com/docs/bundle/yokohama-it-business-management/page/product/it-finance/task/...

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hemanth M1
Giga Sage
Giga Sage

Hi @M_Tomy ,

 

Have you tried trend type as below

HemanthM1_0-1753884574189.png

 

HemanthM1_1-1753884633869.png

 

 

Accept and hit Helpful if it helps.

Thank you,
Hemanth
Certified Technical Architect (CTA), ServiceNow MVP 2024, 2025