How to create/run a report that shows all issues over several years

[Jay]

Hello,

I need to either build a report or find a way to get Jira to show me a chart of all the tickets/issues that have come into the helpdesk project over several years. A "Volume over time" I dont see that as an option only "past year by month" I need "past 2 or 3 years by month" not sure how to build custom report.

Any suggestions on how to make this happen would be greatly appreciated.

Thanks,
Jay

[Jay · Accepted solution]

Carla Ann Rowland COMMUNITY LEADER 

Hi Jay,

I mocked up some data and using a created vs Resolved graph doesn't display nicely and you cannot parse the created date because for this gadget is a series.

1. Create your filter: e.g. project=myservicedesk and Createddate<endofyear() and save it. It should capture all your created tickets
2. Go to your dashboard and choose the created vs. resolved gadget. I  did: 
   1. Choose your filter
   2. period: Monthly
   3. Days Previously: the number of days 1095 is 3 years
   4. Trend: No
   5. Display Versions: only major versions
   6. Collection is count
3. The graph will display see my attached graphic. As you see it displays 3 years on same graph. It isn't super pretty because I didn't make any resolved issues.

[Bloompeak Support · Accepted solution]

Hi @Jay

An alternative way is to use Reports - Charts and Graphs for Jira app developed by our team.

• You can create custom, flexible and colorful bar charts and table views for any data you want/need.
• You can set X axis to be any parameter like Created(month), Assignee, Sprint, Fix Versions etc.
• You can set Y axis to be any parameter like number of issues, sum of remaining estimates, average of story points etc.
• You can group your data on any field(Sprint, Status, Assignee, Component, Project etc.) you want.
• You can choose various date ranges like All Time, Last Year, Last 3 Months, Last 6 Months etc.
• You can order the results by drag and drop.

Here is a sample report that shows number of issues created by month.

Hope it helps.

[Ravi Sagar _Sparxsys_]

Hi @Jay 

Did you try looking Created vs Resolved gadget? You can configure the report to show Date range as "Past year by month".

or you can look at "Recently Created" gadget and select Period as Monthly and Days Previously as 365.

I hope it helps.

Ravi 

[Jay]

Hi Ravi,

Yes, I  did look at the Created vs. Resolved. There is still the limitation of Year by month for the display. 

As for the Recently Created, it will only go back so far. I dont know what limitation is there. I'm looking for a multiple year range. Do you know how to do this? If so can you please provide the query?

Thanks,
Jay

[Jay]

[Jay]

[Jay]

As you can see by my screenshots, I have the date range set back to Jan of 2019 to today's date. and when I save the query, it only allows me to display for the past year. How can I get a report that shows more than just one year?

[Carla Ann Rowland]

Hi Jay,

I mocked up some data and using a created vs Resolved graph doesn't display nicely and you cannot parse the created date because for this gadget is a series.

1. Create your filter: e.g. project=myservicedesk and Createddate<endofyear() and save it. It should capture all your created tickets
2. Go to your dashboard and choose the created vs. resolved gadget. I  did: 
   1. Choose your filter
   2. period: Monthly
   3. Days Previously: the number of days 1095 is 3 years
   4. Trend: No
   5. Display Versions: only major versions
   6. Collection is count
3. The graph will display see my attached graphic. As you see it displays 3 years on same graph. It isn't super pretty because I didn't make any resolved issues.

[Jay]

Thank you @Carla Ann Rowland

That is exactly what I needed! Appreciate your assistance :)

[Carla Ann Rowland]

you are welcome, happy it helped.