compare original effort with time spent

René Steg October 24, 2012

I tried to compare in a filter the original effort with the time spent and JIRA claimed that this is an invalid comparison (The value 'timespent' for field 'originalEstimate' is invalid) . I would like to figure out all tasks which took longer than the estimate this way. Any thoughts?

2 answers

1 accepted

10 votes
Answer accepted
Stephane Oberlechner
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 24, 2012

Hi René,

Try JQL language & the Keyword "workratio" (available on my jira 4.4.4). I use it to identify jira where I spent more time than expected. ("workratio >100").

Hope this help.

Steph from France

Pandiyan Thangarasu July 30, 2018

Nice, it's working

Mohamed_BOUKHRIS September 20, 2019

Hi, "workratio" do not take account the original estimate & time spent in sub-tasks :( 

Like Mathieu Duczmanski likes this
3 votes
johndpatton October 25, 2012

If you want to read more on the topic:

https://confluence.atlassian.com/display/JIRA/Advanced+Searching

WorkRatio is calculated as follows: workRatio = (timeSpent / originalEstimate) x 100

Suggest an answer

Log in or Sign up to answer