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

Damien RENAUD
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 23, 2023

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.

Automation-Jira.png


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 

2 answers

1 accepted

2 votes
Answer accepted
Damien RENAUD
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 23, 2023

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

Automation-Jira (1).png

vee
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 16, 2023

Thank you so much for this!

Josh Pritt
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 14, 2024

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.

0 votes
Marco Rodrigues April 15, 2024

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events