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

compare original effort with time spent

René Steg

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?

Accepted answers

Stephane Oberlechner

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

All comments

Stephane Oberlechner

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

John D Patton

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

Pandiyan Thangarasu

Nice, it's working

Mohamed_BOUKHRIS

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