Forums

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

Does Jira track the date (or date range) a Story is moved into a new Status?

Thomas Harrington
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 5, 2020

I want to create a Dashboard Gadget that displayed Stories based on the date/date range they were moved into working status. Right now I can only figure out how to display based on Created Date.

4 answers

0 votes
Emre Toptancı _OBSS_
Atlassian Partner
November 5, 2020

Hello Thomas,

Jira does not offer this functionality out of the box.

To get such a behavior, you can use a custom date field.  let's call it "Current Status Date". You can modify your workflows and use the "Update Issue Custom Field" post function in each transition to write the date of transition to "Current Status Date" field. This way, you will be able to see "Current Status Date" as a field on your issues and also use it as a column on your dashboards.

 

Actually what I explained above is a manual solution and requires the modification of your workflows. It gets exponentially more complex as you want to track different dates. If you are interested in a ready built solution, 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.

tisCloud_FirstTransitionToStatusDate_Report.png tisCloud_MainPage_Chart_Pie_ExcludeMarked.png tisCloud_StatusSelection_Consolidated_output.png

Time in Status contains 4 different date reports that show first/last entry/exit dates for all statuses. You can put these reports to your dashboards too.

Additionally, the app also gives you reports that show how much time each issue spent on each status or assigned to each assignee. You can calculate averages and sums of those durations grouped by issue fields you select. (For example see the average InProgress time per project and per issuetype). You can also combine statuses into consolidated columns to see metrics like Cycle Time or Lead Time.

Time in Status uses issue histories to produce its reports so you don't need any configurations on your workflows and you can get reports on your past issues as well.

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.)
  • Define your custom calendars for more accurate duration reporting.
  • Export your data as XLS, XLSX or CSV.
  • Access data via REST API.
  • Visualize your data with various chart types.

Timepiece - Time in Status for Jira

EmreT

0 votes
Zoryana Bohutska _SaaSJet_
Atlassian Partner
November 5, 2020

Hi @Thomas Harrington 

You can consider tool from marketplace like Time in status for jira cloud (by saasjet). It lets you monitor time issue come in each status for the first time. This data from the app is available for Jira Dashboard.

2020-11-05_23-21-11.png

0 votes
Mehmet A _Bloompeak_
Atlassian Partner
November 5, 2020

Hi @Thomas Harrington ,

The info is available inside Jira and you can get it using for each issue over Jira rest api as below. Then you need to parse the response and extract the data.

JiraRestApi-History.png

Or, you can try Marketplace apps which do the parsing and calculation for you. 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.

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).

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

Hope it helps.

0 votes
Bill Sheboy
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 5, 2020

Hi @Thomas Harrington  -- Welcome to the Atlassian Community!

Yes, that information is captured in the logs, and no, it is not easily accessible except by reading each issue's log.

What could you do...

  • You could look at the cumulative flow diagram report to see how many issues were in statuses over time.  The versions of this report are different for classic and NextGen projects, so depending on your project one may help you more.
  • There are for-purchase marketplace add-ons to help visualize status changes over time more easily
  • You could create filters to find issues in status values for a range of time, and visualize that with a dashboard.  For example: project = myProject AND status WAS "In Progress" DURING ("2020/01/01", "2020/01/15")  That method would be maintenance heavy to keep it up to date.  You can learn more about advanced searches here: https://support.atlassian.com/jira-core-cloud/docs/advanced-search-reference-jql-operators/ 

Best regards,

Bill

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events