How to create a JQL filter that displays all issues with exceeded estimate

[Антон Гапеев]

Hello everyone!

Has anyone encountered the need to filter tickets in which logged time exceeds the estimate?

I've tried to implement quick filters such as time spent > original estimate, but it doesn't work, only natural figures are allowed.

Also if there are alternative ways for this analytics be implemented, please share the experience?

Best,

[Max Foerster - K15t · Accepted solution]

Hi @Антон Гапеев

you're welcome! workRatio is not very known among Jira users :) Could you please accept the answer as a solution so other users can find an answer to that question faster? And please accept this comment as the comment above has lost the possibility during moving this topic from discussions to questions.

[Max Foerster - K15t]

Hi @Антон Гапеев,

please have a look at the available workRatio (workRatio = (timeSpent / originalEstimate) x 100) field in JQL. Best, Max

[Антон Гапеев]

It seems that this is exactly what I need!

I`ve entered workratio > 100 and it works.

Thank you, Max! :) 

Cheers

[Emma]

hello! it is possible to see the exceeded original estimate with a certain percentage?

E.g: I want to see what are the tasks that exceed with 10% the original estimate. Thank you!