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 - LNG
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?

@Dr Atul - 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.

Hemanth M
Tera Sage

Hi @M_Tomy ,

 

Have you tried trend type as below

HemanthM1_0-1753884574189.png

 

HemanthM1_1-1753884633869.png