How to learn with JQL in which tasks "Logger time" exceeds "Estimated time" ?

[Maxim Vaskov]

I need a filter so that I can see who the "Logged time" has hit more than the time than "Estimated time"

any thoughts? 

Thank you

[Ignacio Pulgar · Accepted solution]

Natively, you can get all issues where the time spent is higher than the original estimate with this JQL:

workratio > 100

By showing the assignee in the Issue Navigator, you will get the info you need.

You might want to save that query as a filter in order to feed a Pie Chart by Assignee in a convenient dashboard for keeping track of things like this.

Hope it helps.

[Maxim Vaskov]

Very grateful! 

[Ignacio Pulgar]

Glad to help!

Mind that you can filter that further for getting only issues where the user who had logged work belongs to a certain group, with a query like:

workratio > 100 AND worklogAuthor IN membersOf("jira-administrators")

[Mikhail_Kopylov]

Hi, Maxim,

you can write an add-on with a custom JQL Function that will filter issues in your favourite way.

Or you can use third-way addons like ScriptRunner : https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_expression