Search criteria in Jira to compare & view deviation in numeric field value

[Anamika Sharma]

I want to prepare a query (search criteria) in Jira to view effort estimate difference.

For example:

If in initial Jira stage, effort estimates was 10 days captured under field 'ACF0 estimates' and in later Jira stage actual effort logged in by team is 12 days under field 'ACF1 estimates'.

I require help with advance search syntax to fetch list of Jira tickets where field value does not match, i.e. 'ACF0 estimates' != 'ACF1 estimates'.

Thanks & Regards

[Walter Buggenhout]

Hi @Anamika Sharma ,

If you use the built in Original Estimate / Time Spent (Time tracking) fields in Jira, there is a standard feature you can use for this. There is a default field called workratio that does exactly this calculation for you. You can even use that field in JQL to search for issues where the actual time spent is higher than the original estimate. That would be:

workratio > 100

The 100 stands for 100%, as workratio is calculated as a percentage.

Hope this helps!