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

[Walter Buggenhout]

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! 

[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

[Daniel Bermudez]

Hello!! Thank you very much, I tried with the remaining estimate and it worked, but it results that the client dont want it that way

What they need is that, the "Time Diffrence" field, shows the exact difference between the estimated time and the time spent, for example, if the estimated time is 1 day, and it lasts 3 days to resolve it, it need to show "-2 days" 

Is there something i can do to do it in that way? 

[Samuel Gatica _ServiceRocket_]

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

[Daniel Bermudez]

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?