Original Estimate VS Time Tracking

[Özge Özgenç]

I want to compare the original estimate and time-tracking data for issues that are in a sprint. So, I can evaluate if estimation time guesses failed or were successful and how is the failure rate for a sprint is. 

How can I compare these data and see them as a report?
Is there a way to do it with confluence tools, dashboard widgets, etc?
I'm open to any suggestions. Thanks.

[Trudy Claspill · Accepted solution]

Hello @Özge Özgenç 

The Work Ratio field will show what percentage of the Original Estimate has been consumed by time logged. You can see the information in the Advanced Issue Search screen when you use List View and add the Work Ratio column. A Work Ratio over 100% indicates more time was logged than in the Original Estimate.

The same information can be shown in Confluence using a Jira Macro.

[Özge Özgenç]

Hi @Trudy Claspill 
Thank you a lot you are a lifesaver! :) I tried the advanced issue search and it works. However, I couldn't find Jira Macro in Confluence. There is task report and it seems similar. Are you using task report template?

I couldn't edit the columns to display field. I got this error:

and also I would like to filter it to see only one sprint. 

[Trudy Claspill]

The Task Report macro in Confluence is not the same as the Jira Macro.

Are your Confluence and Jira instances on the same site, using the same base URL?

Have you established an Application Link between the Confluence and Jira instances?

If there is no Application Link and/or the two products are not on the same site then that could explain why the Jira Macro is not currently available in Confluence.

[Özge Özgenç]

It works thank you. 

[Mark Barber]

The suggested Work Ratio does not take into account sub-tasks.  I suggest using the "Time Tracking Report" that can be found in the "Reports" menu for your Project.  This provides a detailed report that also includes sub-tasks.