Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Dashboard Gadget - Actual VS estimate time

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 :)



3 answers

1 accepted

1 vote
Answer accepted

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. 


Thank you very very much!!!

I think that is what we wanted :)



really great answer! thanks you!


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

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.


Hi @Walter Buggenhout _ACA IT_

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


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.pngOn dashboards, you can simply display the field in a standard Filter Results gadget:

Screenshot 2019-12-12 at 12.41.18.png

Like Veronika Dvorska likes this

Great! Many thanks! 

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

@Sarah Noor You can save a filter with the below JQL and then add a Pie Chart gadget to your Jira dashboard. The gadget will show % of underestimated issues per user.

project = Development AND assignee in membersOf(group_name) AND resolution is not EMPTY AND originalEstimate != 0 AND workratio > 100
  • assignee in membersOf(group_name) will filter out members of a specific group
  • resolution is not EMPTY will filter out only resolved issues
  • originalEstimate != 0 will filter out issues that were not estimated

You can use assignee = username if you want to see issues for someone specific.

do you know if work ratio calculates based on all the subtasks of a task/story as well ?

@Sarah NoorI believe the work ration calculation works at the issue level where you have enabled the Time Tracking fields and are therefore capturing Original Estimate, Time Spent, etc.

For example, if you use Time Tracking at the standard issue type level (which is what @Walter Buggenhout _ACA IT_ appears to be doing above as he is showing work ratio on a Story) you can can show work ration at the Story level; if you have it enabled at the Sub-task level then you can show it there.

I think you are asking if you can "roll up" the work ratio from each of the Sub-tasks within a Story and display an overall work ratio for the Story (much like the rolled up Time Tracking metric shown on the right side of the standard issue screen when Original Estimates are logged for Sub-tasks and then actual work is logged, too). 

I've tried to figure out how to make this work, but without any luck. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,528 views 22 32
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you