Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Антон Гапеев August 1, 2018

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,

2 answers

1 accepted

0 votes
Answer accepted
Max Foerster - K15t
Community Champion
August 1, 2018

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.

2 votes
Max Foerster - K15t
Community Champion
August 1, 2018

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

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

Антон Гапеев August 1, 2018

It seems that this is exactly what I need!

I`ve entered workratio > 100 and it works.

Thank you, Max! :) 

Cheers

Emma November 1, 2023

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!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events