Possible to report on when issues were closed or when assignee was assigned to someone?

[Hoc]

Hello,

is it possible to report on when a issue was closed or when an assignee was was assigned to someone?

Thanks!!

[Yuliia_Borivets__SaaSJet_]

Hi @Hoc 

You can consider solutions from Atlassian marketplace. There are 2 apps that can help in your case:

1. Time in Status for Jira Cloud and its Status Entrance Date report. Here you'll get a date on when an issue was closed, or when it entered any of the statuses.

2. Issue History shows all the history changes that have been made to each issue. Here you can get the time when the issue was closed, when it was assigned to someone, or any other changes.

These add-ons are developed by my team, so let me know if you've got any questions.

Kind regards, Yuliia

[Alex van Vucht (GLiNTECH)]

Yes:

By "Closed", that usually means when a resolution was set. Make sure you are setting a resolution on all issues when they change to a status in the "Done" status category to keep understanding where your work is at easy and manageable.

"resolution != Unresolved" is generally used to filter tickets that don't need any more work. There is a "Closed" status but that is an ITIL meaning for "Closed" and generally isn't useful for reporting.

You can use the WAS operator to find issues where the assignee was ever someone in particular.

You can use the CHANGED operator to find issues that were ever assigned at all. Just "assignee CHANGED" is sufficient.

You can use the query "assignee CHANGED and assignee IS EMPTY" to find issues that once had an assignee but now do not.

[Emre Toptancı _OBSS_]

Hello @Hoc,

For status transition dates of individual issues, you can see each issue's History or Transitions tabs. For Assignee changes, you can also see Issue History Tabs.

These data are not available as field values so it will not be possible to see them in Jira issue search screen.

You can try creating custom fields and using automation rules to populate those fields in workflows. Then these dates can be shown in search screen as well. The downsides of this solution are: You have to build it yourself so it will be expensive to build and maintain, it is hard to scale because as the number of statuses increases you will need to do more configuration, it will work for status transitions but I am not sure if it works for assignee changes. You'll have to try.

For a report that lists issues with the requested dates, you have to use a marketplace app or get the data using REST API and do some custom code development to build the report yourself.

In case you are OK with using a marketplace app, our team at OBSS built Timepiece - Time in Status for Jira app for this need. It is available for Jira Server, Cloud, and Data Center.

Time in Status mainly allows you to see how much time each issue spent on each status or assigned to each assignee. The app also has date reports that show transition dates for each status. I am afraid we don't have anything for assignee dates either.

  

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well.

Time in Status reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts.

Using Time in Status you can:

• See how much time each issue spent on each status, assignee, user group and also see dates of status transitions.
• Calculate averages and sums of those durations grouped by issue fields you select. (For example, see average InProgress time per project and per issue type.)
• Export your data as XLS, XLSX, or CSV.
• Access data via REST API. (for integrations)
• Visualize data with various chart types.
• See Time in Status reports on Jira Dashboard gadgets (released for cloud, server&DC gadget coming soon)

Timepiece - Time in Status for Jira

EmreT

[Mehmet A _Bloompeak_]

Hi @Hoc ,

You can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count. By default the report is based on status but you can also get report for assignee, e.g when each issue is assigned to someone.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports(eg. average in progress time per project). And all these are available as gadgets on the dashboard too.

Here is the online demo link, you can see it in action and try.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.