Tracking issues estimates vs actual dev time

[Matthieu Massart]

Hi everyone, 

Here is my problem. I would like to automatically compare two things:

1. An estimated dev time in days (eg: 6) 

I was planning on collecting 1. in a custom field which I could then automatically be exported to google sheets to do my analysis (thanks to a plug-in). The estimated dev time would be inputted manually so there are no issues with data collection here.

2. The actual dev time 

This would be defined as the difference between the date at which development starts (issue = in progress) and the date at which it ends (issue = done). Both "in progress" and "done" are steps in our Jira workflow.

I was hoping to get both dates in two different custom fields to then export this information to google sheets to do my analysis (computing the actual dev time and then comparing the result with 1.) 

If an issue changes to "in progress" tomorrow, how do I get tomorrow's date in a custom field?

Thanks in advance :) 

PS: feel free to let me know if you know of a different approach to this problem!

[Sami Linnanvuo {Screenful}]

Hi Matthieu, 

You can create such a report using the custom charts feature of the Screenful add-on. Here's an example report showing two trend lines: one for the estimated dev time (using a custom field) and another for the actual cycle time measured from when work was started to the completion of the issue:



This chart is showing a 30 days rolling average from all the completed issues during the last 3 months. There's a 21 day free trial so you can give it a try with your own data.