Jira Automation - send an email when time spent is greater than 75% of time estimated

[Damien RENAUD]

Hello, 

I would like setup an automatic rule which send an email when the time spent on a ticket is equal to XX% of time estimated.

I created a basic rule which compares time spent and time estimated, it's works, but when I want to adapt the rule for a certain amout (ie : 50%) it doesn't work.

What I can conclude when I test : 

{{issue.timetracking.TimeSpent}}
greater than
{{issue.timetracking.originalEstimate}}
--> OK

{{issue.timetracking.TimeSpent}}
greater than
({{issue.timetracking.originalEstimate}}*0.5)
--> NOK (it's triggered even if the time spent is not greater than 50% of time estimated)

I think that the ratio of 0.5 can't be used in this kind of field...

Do you have an other way to set a % of the original estimate ? 

Thank you 

[Damien RENAUD · Accepted solution]

Actually I faced this issue by using workratio field to avoid time estimated calculation : 

[vee]

Thank you so much for this!

[Josh Pritt]

Do you get multiple emails as time is logged and the workratio is 60%, 75%, 80% etc.?
How could we avoid that and only get the email once?  Is there a flag we can set and have it only send the email the first time around?  I created my own variable but it looks like the scope only exists in that one run of the rule and doesn't persist to the next run of the rule.

[Gordon McDonald]

I have the same problem Josh, the email is sent each occasion someone records time spent to a ticket after 50%. Anyone found a solution so that the email is only sent once?

Edit: I added a new label "time-50%-done" to check each time as well, which also gets updated.

[Marco Rodrigues]

Question: what was the JQL you've added in the Scheduled trigger?