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; } } }

Dashboard Gadget - Actual VS estimate time

Anna Veneti

I would like to be able to see in my dashboard which cards are overbooking on time (for a project) in order to control the time budget.

I have searched everything , i found only one gadget (Estimate Accuracy Gadget) that is no longer available for the latest version of Jira.

Am i the only person with this problem? how do you do your day -to -day monitoring of a project , to make sure that if they are delays are early identified and communicated to the customer? at the moment i need to go to the board of the project.

please help

Thanks

Accepted answers

Walter Buggenhout

There is a field called workratio in JIRA which shows you exactly the rate of original estimate vs time spent. It is a percentage.

This JQL statement shows you all issues where time spent is higher than the original estimate:

workratio > 100

If you combine that with the project you want to select issues from and any other relevant criteria, you have a clear selection of issues to add to a dashboard gadget.

This is only part of the story of course. This works at issue level only. So it won't tell you which issues have been solved way faster than estimated. There are a lot of cool add-ons available for reporting, follow-up on progress, forecasting and so on.

All comments

Walter Buggenhout

There is a field called workratio in JIRA which shows you exactly the rate of original estimate vs time spent. It is a percentage.

This JQL statement shows you all issues where time spent is higher than the original estimate:

workratio > 100

If you combine that with the project you want to select issues from and any other relevant criteria, you have a clear selection of issues to add to a dashboard gadget.

Anna Veneti

Thank you very very much!!!

I think that is what we wanted

thanks

anna

Lillian Shibata-Salley

Hi - I'm trying to find that field and can't find it anywhere. Trying to get a % to display based on estimation and time worked.

Thanks

Zhang Sheng

really great answer! thanks you!

谢谢！

Sarah Noor

hey, can anyone let me know if this field is still available and how can i see this in new jira view?

Veronika Dvorska

Hi @Walter Buggenhout

maybe a stupid question, but what 100 means? Is it like 1,6 hours ? And can you recommend any suitable gadget for a such jql?

Thanks for answer

Veronika

Walter Buggenhout

Hi @Veronika Dvorska , 100 is 100%. In simple words: time spent is more than the original estimate on the issue.

This is standard jira functionality. Although in JQL you query for it as 'workratio', you can add the field in the issue navigator as 'Work Ratio' (spelled with 2 words):

Screenshot 2019-12-12 at 12.37.31.png On dashboards, you can simply display the field in a standard Filter Results gadget:

Screenshot 2019-12-12 at 12.41.18.png

Veronika Dvorska

Great! Many thanks!

Sarah Noor

how can we group by or filter this for individuals? any thoughts ?

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-software