JQL Query for finding the most overrunning subtasks in a sprint

[Vera M]

I am currently using the workratio filter to find the most overrunning subtasks in a sprint:

issuetype = Sub-task AND Sprint = 5116 ORDER BY workratio desc

It's useful to be able to find the poorly time estimated tickets this way. However, workratio uses proportion and now I want to find out which subtasks overran by the most amount of time. e.g. 2 days over original estimate, 1.5 days over orginal estimate, 1 day over , 4 hrs, 2hrs etc.

I am really struggling to work out how to put together a query for this., so I would appreciate the help.

[PADMA KOTHAKOTA]

Hi @Vera M,

I think below JQL may help you . It will show the issues where the logged work is greater than Original estimate

issuetype = Sub-task AND Sprint = 5116 and workratio > 100