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.
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.
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:
Timepiece - Time in Status for Jira
EmreT
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
Best regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.