nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

- Agile board - JIRA.png

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.

Accepted answers

Trudy P Claspill

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.

Screen Shot 2023-03-30 at 11.43.42 AM.png

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

Screen Shot 2023-03-30 at 11.47.18 AM.png

All comments

Trudy P Claspill

Hello @Özge Özgenç

Screen Shot 2023-03-30 at 11.43.42 AM.png

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

Screen Shot 2023-03-30 at 11.47.18 AM.png

Özge Özgenç

Hi @Trudy P 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 P 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.

Screen Shot 2023-04-03 at 9.24.44 AM.png

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud