jira daily resolved report

I have a team that didn't like their sprint ending on Fridays, a day where we generally avoid pushing major changes to production. They switched their sprints from Mon-Fri to Thur-Wed for the last quarter. To see if that would help things.

I'd like to create a report that would show the number of issues that were resolved/closed on a daily basis. This would allow the team to see if they were able to successfully move their deployments away from Friday.

Generating the query is fairly easy:

project = foo AND status in (Resolved, Closed) AND resolutiondate is not EMPTY ORDER BY resolutiondate DESC

But I'm not sure which project report I should use to show this on a day-to-day measurement. Created/Resolved gives me extra info; if there was just the resolved view that may provide what I need. Any suggesgtions?

 

2 answers

1 accepted

It looks like this may not be possible. I ended up searching JIRA's db schema for the correct pieces of information and then connecting JIRA to Chartio to visualize data.

If you do not know which project to select you can do not specify project at all. Then you will get result from all projects that you have browse permission.

Hi Vasiliy!

 

I know the project I want to track; I'm not sure how to get a report that shows me the number of resolved tickets each day.

Here it is: (resolutiondate >= startOfDay() and resolutiondate <= endOfDay())

Hi Vasiliy, 

Thanks... but I know how to create the search query and get the results. I'd like to show these results in a report: a chart, a dashboard widget, something like that. The closest I've found is to use the "created vs resolved" chart, but that report shows more information that I'm interested in seeing. I want to se JUST resolved issues. 

Suggest an answer

Log in or Join to answer
Community showcase
Emilee Spencer
Published yesterday in Marketplace Apps

Marketplace Spotlight: DeepAffects

Hello Atlassian Community! My name is Emilee, and I’m a Product Marketing Manager for the Marketplace team. Starting with this post, I'm kicking off a monthly series of Spotlights to highlight Ma...

38 views 0 3
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot