Get the overbooked time of a ticket

[Patrick Alexander]

Hi There,

i want to calculate the time spent on an issue over the original estimate in a single field. For example. Original Estimat = 16h. Time spent = 20h. So i need to get the 4h between.

I tried to use smart values in Jira Automation. But i only get an empty field.

Here ist my syntax:

{{worklog.timeSpent.diff(issue.fields.timeestimate).hours}}

Who can help here?

Thank you

Patrick 

[Murat Seven · Accepted solution]

Hi @Patrick Alexander and thanks for your question.

Can you try this smart value;

{{issue.fields.timeoriginalestimate.minus(issue.fields.timetracking.timeSpentSeconds).divide(60)}}

you can following jira-smart-values-math-expressions.

Hope this helps. If the issue is resolved, you can vote and accepted for this comment.

Best,

Murat Seven

[Patrick Alexander]

Hi Murat,

greate work! This is nearly what i need. Only one thing:

Can i restrict this to only positive values. So if there i no overbooking and some estimated hours left the calculation should not be done. Maby i can use the grather then? Syntax: gt(value)?

Thanks for your help!

[Murat Seven]

Hi @Patrick Alexander 

Thanks for response.

Yes, you can use gt(value) for your request. If you encounter any issues, I'm here to help.

If the issue is resolved, you can vote and accept for this comment.

Best regards,

Murat Seven

[Patrick Alexander]

Hi @Murat Seven 

Thanks for the help so far. I have now tried this with gt(value) and unfortunately failed. So I tried again with the help of the Advanced compare condition. But here too the rule does not work properly. Can you give me another hint.

[Murat Seven]

Hi @Patrick Alexander 

Could you test the first value and second value fields with the {{}} expression?

like this;

{{issue.fields.timeoriginalestimate}}

[Murat Seven]

Hi @Patrick Alexander 

I hope you are having a wonderful day!

Is there any update regarding my recent message?

Best,

Murat Seven

[Patrick Alexander]

Hi @Murat Seven 

i got it! Great work for now. Thank you so much for helping me out here!

[Adaeze_Jude_HEROCODERS]

Hi @Patrick Alexander,

Clockwork Automated Time Tracking & Timesheets Pro provides you with similar functionality instantly using our reporting tool.

On the Timesheet report, which can be broken down per issue, we have the Actual vs Estimate feature, which displays two additional fields. This is the Original estimate and the current amount of time remaining. 

This offers an immediate overview of these figures.

The sum of the estimated, remaining, and currently logged time will show on the Epic and you can equally drill down to see individual Child issues.

Let me know if you would like to discuss more about this feature and the App, please let us know here.