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; } } }

jira daily resolved report

Bryan Collick

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?

Accepted answers

Bryan Collick

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.

All comments

Vasiliy Zverev

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.

Bryan Collick

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.

Vasiliy Zverev

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

Bryan Collick

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.

Bryan Collick

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.

Matt_Roberts_qljwp4

was an answer found on this?

Bryan Collick

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

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-administration

jira-core

report

resolve