Finding the time frame of Jira when status were changed

[sunil Kumar BV]

I need to calculate ATA in Jira where i need find time difference 

from Open time frame ( created) but need "In progress" time frame "review" time frame 

how can i find these time frame is there any specific field i can find or call i create the custom field in local server ( No Jira cloud is available)

[Rahul_RVS]

Hi @sunil Kumar BV 

Welcome to the community !!

For a readily available solution, to analyze status transition dates, you might be interested in a mktplace app,

Time in Status Reports 

The below report can meet your requirement. Also the app has 20+ reports to meet a variety of use cases.

More details here.

Disclaimer : I am part of the app team for this add-on

[Petru Simion _Simitech Ltd__]

Hi @sunil Kumar BV ,

If you are open to using apps you can use Time in Status Dashboard for Jira  an app released by our company.

You have two perspectives to analyze how much time was spent in each status and also how many times an issue was present in each status.

You can export to csv and use Excel to sum up values as you wish.

You can search all issues or filter out according to various criteria.

Regards, 

Petru

[Birkan Yildiz _OBSS_]

Hey @sunil Kumar BV ,

Jira's built-in features can fall short of getting the data you want. So, if you are open to using a marketplace app, Timepiece - Time in Status for Jira’s Status Duration report will give you exactly what you're looking for. It provides a clear breakdown of how long each issue spent in every status of its workflow, including 'In Progress' and 'Review'.

You can also use it to easily calculate the total time from creation to resolution and even configure custom work calendars to exclude non-working hours from the calculation, giving you much more accurate data.

You can get average, sum, median, or standard deviation reports.

Besides, you can automate these reports or create Alarms to inform you once your preconfigured conditions are met.

Not just that, Timepiece also offers Assignee Reports, Count Reports, Date Reports, and more.
You can check it out on the Atlassian Marketplace. Hope this helps you get the data you need.

Disclosure: I'm on the team that makes Timepiece - Time in Status for Jira.

[Iryna Komarnitska_SaaSJet_]

Hi @sunil Kumar BV ,

If you're open to using a marketplace app, I can recommend one developed by my team.

Time in Status app has several built-in reports that can help you.

One of them is Status Entrance Date, which shows the date and time when the task was transferred to it.

Another is the basic Time in Status report, which shows how much time tasks are spent in different statuses.

I hope you find it useful!

[Marc - Devoteam]

Hi @sunil Kumar BV 

Welcome to the community.

You can query the database or use the API, see https://developer.atlassian.com/server/jira/platform/database-change-history/ , as you need the issue history for this.

With automation and API call you could calculate this using smart values in automation and store the outcome into a new custom field.

Or you can look at 3rd party application on the marketplace to aid you in this.