Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,456,540
Community Members
 
Community Events
176
Community Groups

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

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

3 answers

2 accepted

4 votes
Answer accepted
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.
0 votes
Answer accepted
Bloompeak Support Marketplace Partner Mar 01, 2022

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.

NumberOfIssuesCreatedByMonth.png

Hope it helps.

2 votes

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 

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

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?

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.

created vs resolved.PNG

Like Jay likes this

Thank you @Carla Ann Rowland

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

you are welcome, happy it helped.

Like Marjorie likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.15.0
TAGS

Atlassian Community Events