Difference between Original estimate and time spent in a Jira Filter

Question

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?

Walter Buggenhout · Answer

Hi @Daniel Bermudez,

While reviewing some older questions, I noticed this one still being out in the open. If you want to have a look at this for single issues, Jira has an out of the box field called Work Ratio. It is an out of the box field that compares the value in the original estimate field to time spent and presents the outcome (in real time) as a percentage.

You can display the field in filter results, but also on a dashboard gadget, where it will tell you if you're below / on / over the estimate. You can even build JQL filters on it, something we do quite regularly for bringing issues to our attention that are still being worked on, but nearing their estimates.

Hope this helps!

Daniel Bermudez · Answer

Mmm, but then, I need something to hold the estimated time

For example I need a custom field named: Estimated Time to Finish

I need that the user can enter for example: 5 hours

This will trigger when the ticket enters to "In progress" Status

Then another custom field called: Real Time Spent

Then I can add an another automation that calculates the time between the "Estimated Time to Finish" and the time by the ticket transitions to "Resolved"

Is this logic correct? how can i make this work?

Samuel Gatica _ServiceRocket_ · Answer

Hi @Daniel Bermudez

Then you will need to set the Due date and create a custom field, then calculate the difference using Automation and the Date difference function

Best regards

Sam