nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

John Funk

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

All comments

John Funk

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

dashboard

report