How can I obtain a status change date and time report for all issues in a sprint?

[Arunsakthian M R]

I'd like to get the report on how many times the status of each issue in the sprint was changed and how much time each assignee spent in each status without any third party plugin in the jira cloud.

[Valeriia_Havrylenko_SaaSJet]

Hello @Arunsakthian M R 

Jira does not natively provide a way for you to report how many times the status of each issue in the sprint was changed and how much time each assignee spent in each status. But you can use a combination of custom fields and automation to record those values without a third party app.

Issues in X project with issue type x that were transitioned to status X between date and date

Project = Negotiations AND status CHANGED TO "Accepted" and (updated >= "2022/12/26" and updated <= "2022/12/30")

Issues which has historically had a status of "Ready for Deployment" and now are in status "Ready for Deployment"

Status was "ready for deployment" AND status = "Ready for deployment"

Issues which has status "ready for deployment" and had status "ready for deployment"

Status was "ready for deployment" or Status = "Ready for deployment"

JQL for Filter by date and status

updatedDate >= -5d OR status != DONE

More information could be found here:
https://support.atlassian.com/jira-core-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-CHANGEDCHANGED

Any way, i recommend you to try Time in Status for Jira, (developed by my team) that generates 7 types of status reports including Status Count 


and Assignee time reports

Add-on has a 30-day free trial version and free up to 10 users. 
Please, let me know if you have any questions

Hope it helps 😌

[Amay Purohit_RVS]

Hi @Arunsakthian M R 

Welcome to the community !!!

AFAIK, these reports are not available OOTB. If you are open to try out a mktplace solution, to get this data you can try out our app.

Time in Status Reports 

The add-on provides multiple reports, including the status count and time with Assignee reports.
The app is free upto 10 users

Disclaimer : I work for the vendor who built this app

 

[Gizem Gökçe _OBSS_]

Hello @Arunsakthian M R ,

Welcome to the community!

I understand that you are not looking for a paid solution right now. However, if you ever need it I can recommend Timepiece - Time in Status for Jira which is built by my team at OBSS. It is available for both  Jira Cloud, and Data Center.  

Time in Status mainly allows you to see how much time each issue spent on each status or each assignee. You can combine the time for multiple statuses to get metrics like Issue Age, Cycle Time, Lead Time, Resolution Time etc. 

  

Time in Status mainly has several types of time reports (showing how much time each issue spent on each status, assignee, or group) but the app also has Status Count and Transition Count reports. These reports show how many times each status and each transition was used by each issue.

  

For all numeric report types, you can calculate averages and sums of those durations grouped by the issue fields you select. For example total in-progress time per customer or average resolution time per sprint, week, month, issuetype, request type, etc. The ability to group by parts of dates (year, month, week, day, hour) or sprints is particularly useful here since it allows you to compare different time periods or see the trend. 

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. And the app has a REST API so you can get the reports from Jira UI or via REST. Also you can export the reports in to various formats easily. 

Visit Timepiece - Time in Status for Jira to explore how our JIRA add-on can revolutionize your metrics measurement process. Enjoy a 30-day free trial to experience the full range of features.

If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Hope it helps,

Gizem

[Mehmet A _Bloompeak_]

Hi @Arunsakthian M R

Welcome to the Atlassian Community!

Jira doesn't have a built-in solution for the reports you mentioned. You can try Status Time Reports app developed by our team. It mainly provides reports and gadgets based on how much time passed in each status.

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

1. To get a report of how many times the status of each issue is changed, you can have a look at Status Count And Entry Dates report. Entry date(see In Development, Ready for Testing, In Testing, In Development columns.) is status transition date and status count(see #In Development, #Ready for Testing, #In Testing, #In Development columns) is how many times an issue is entered to this status.

2. To get a report of how much time each assignee spent in each issue, you can have a look at Time in Assignee report.

App Features:

• This app has a dynamic status grouping feature so that you can generate various valuable reports as time in status, time in assignee, status entry dates and status counts, cycle time and lead time, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month).

• You can search issues by Project, Issue Type, Status, Assignee, Issue Creation/Resolution Date(and any other Date field) and JQL Query.
• Status durations are calculated according to the working calendar you define. 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.
• You can set different duration formats.
• You can export reports in CSV file format and open them in MS Excel.
• You can also add this app as a gadget to your Jira dashboards and reach “Status Time” from Issue Detail page.
• You can enable/disable access to Status Time reports&gadgets and Issue Detail page per project, users, groups or project role.

For further details, you can have a look at Status Time Reports How to Videos.

If you are looking for a completely  free solution, you can try the limited version Status Time Reports Free.

Hope it helps.