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?


3 answers

1 accepted

0 votes
Accepted answer

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. 

was an answer found on this?

@Matt Roberts exporting to excel or using a visualization tool via API may be your best bet.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 09, 2018 in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

254 views 6 0
Join discussion

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