nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Murat Seven

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

All comments

Murat Seven

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

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.

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.

Screenshot 2023-11-13 102733.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud