Dashboard report for issues. Using fields start and end time.

[Christopher Pulis]

Dashboard report query

I need to work out the average amount of issues resolved within a certain time period.  I'm using fields start and end time.  Which gadget and/or JQL is required

Many thanks 

[John Funk · Accepted solution]

Hi Christopher - Welcome to the Atlassian Community!

Not sure that I understand the question completely, but you don't have an average resolved during a certain time period - you just have the actual number resolved during that period. 

It would look like:

Project = ABC and resolved >= 2021-03-01 and resolved <= 2021-03-31

All of the issues resolved on project ABC during the month of March

[Bill Sheboy]

Hi @Christopher Pulis 

Yes, and... to what John says...

You can do the time range but not the roll-up thing with out-of-the-box Jira.  For example show me the resolved issue count average (by month) for the last calendar year.  There are lots of marketplace add-ons for such types of reporting.

Two possible work-arounds are: 

• export to a spreadsheet and use a pivot table
• create a dashboard which shows the approximate counts, by month, for the last year, with separate gadgets for each month.  (This is approximate due to different month durations.)
  • For example, the query for 12 months back would be something like:
  • project = myProject AND resolved >= startOfMonth(-12M) AND resolved < endOfMonth(-12M)
  • project = myProject AND resolved >= startOfMonth(-11M) AND resolved < endOfMonth(-11M)
  • ...

Best regards,

Bill

[Christopher Pulis]

Thanks very much Bill.  I'll give that a try.  Much appreciated.
Chris