Difference between Original estimate and time spent in a Jira Filter

[Daniel Bermudez]

Hi, I need to find out how I can add a filter, that calculates the difference between Estimated Time and Time Spent.

Here is what im trying to do:

I know there is a Worklog option called "Time Remaining" but I cant show that field as a column in the filter, so I created an automation that help me to show that "Time remaining"

This automation works: 

But the thing is that I need that field to be constantly updating, everytime that the "Time Tracking" field changes

I tried to set the trigger like this: 

 

But it didnt work, when you change the value for the Time Tracking field, it does not change the "Effective time" field, the automation just ignores it and doesnt do anything

Any Ideas on how can I make this? 

[Bill Sheboy]

Hi @Daniel Bermudez 

Starting with your JQL filter idea, have you tried adding the "Remaining Estimate" or "Σ Remaining Estimate" fields to the result columns?

https://support.atlassian.com/jira-software-cloud/docs/jql-fields/#Remaining-estimate

Kind regards,
Bill

[Samuel Gatica _ServiceRocket_]

Hi @Daniel Bermudez 

You should be able to calculate the difference using the "Remaining Estimate" field. Then you can use a Dashboard Gadget and use the Time Tracking Report

Make sure that you have correctly configured Time Tracking

Here is an excellent video that will help you with Time Tracking configurations

Best regards

Sam