Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

I would like to record the movement date between the statuses. the new fields are to support the sto

Swaroop November 19, 2020

I would like to record the movement date between the statuses. the new fields are to support the storage of dates. but will not be registered by the user, will be registered by the post functionMicrosoftTeams-image.png

4 answers

0 votes
Emre Toptancı [OBSS]
Atlassian Partner
November 19, 2020

Hello @Swaroop ,

As others pointed out, this data is available in each issue's history but you will need to do some custom development to extract it and turn it into a report.

 

For a ready built solution that offers great flexibility and details, our team at OBSS built Time in Status app for this exact need. It is available for Jira Server, Cloud and Data Center.

Time in Status allows you to see how much time each issue spent on each status or assigned to each assignee as well as entry/exit dates for all statuses. You can calculate averages and sums of those durations and count grouped by issue fields you select. (For example see the total InProgress time per Epic). You can also combine statuses into consolidated columns to see metrics like Ticket Age, Cycle Time or Lead Time.

tisCloud_FirstTransitionToStatusDate_Report.pngtisCloud_StatusDuration_Report.pngtisCloud_MainPage_Chart_Pie_ExcludeMarked.png

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.

The app has Custom calendar support which means you can get your reports based on a 24/7 calendar or your custom business calendar. (This one is important because a 24/7 calendar in most cases shows misleading data. For example an issue created at 16:00 on Friday and was resolved at 09:00 on next Monday seems to stay open for 2,5 days but in terms of business hours, it is only a few hours. You can see this using Time in Status by OBSS.)

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 issuetype.)
  • Export your data as XLS, XLSX or CSV.
  • Access data via REST API.
  • Visualize data with various chart types.
  • Dashboard gadgets

Timepiece - Time in Status for Jira

EmreT

0 votes
Mehmet A _Bloompeak_
Atlassian Partner
November 19, 2020

Hi @Swaroop ,

You can try Status Time app developed by our team at Bloompeak. It provides reports on how much time spent on each status as well as status entry dates and status count.

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 count, average/sum reports(eg. average in progress time per project).

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 but free version, Status Time Free.

Hope it helps.

0 votes
Ravi Sagar _Sparxsys_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 19, 2020

Hi @Swaroop 

As @Walter Buggenhout mentioned this information is already stored in the changed history. If you want to display some of those dates you can definitely use ScriptRunner for Jira.

Also it seems like your workflow has too many statuses. What is your end goal with this approach?

Ravi 

0 votes
Walter Buggenhout
Community Champion
November 19, 2020

Hi @Swaroop,

These transition dates are already logged automatically by the system in the issue history. You can see them mentioned under history at the bottom of your issues.

It may be an option to surface the information with scripted fields, as you can see explained in this related question.

  

Suggest an answer

Log in or Sign up to answer