Sum of original estimates for all Tasks in the Sprint

[tatevikalaverdyan]

Hi Community,

I try to create automation, which will sum up Original estimates from all tasks in a Sprint and send that Data as a Web Request. For example if I have 3 tasks in sprint X, which have 2, 3 an 5 hours estimation I want to get 10 as a result. 

The problem is that I receive only information from single task not for all together. 


Can you help me find a way? 
My automation is this 

{ "Sprint":"{{issue.fixversions.name}}", "Original_estimate":"{{issue.timetracking.originalestimate.sum}}" }

[Bill Sheboy · Accepted solution]

Hi @tatevikalaverdyan 

That may be done using the bulk-handling feature of branches, with the plural {{issues}} smart value: https://confluence.atlassian.com/automation/run-a-rule-against-issues-in-bulk-993924653.html

Rather than using the branch on issues in sprint, please use the branch on JQL to include your test on the issue type.  Then the condition may be removed from the rule.

Kind regards,
Bill

[tatevikalaverdyan]

Thanks for the answer @Bill Sheboy 
I still get e-mail for each task in the sprint

This is the e- mail content

{{#issues}}
These issues are in the sprint
"Sprint":"{{issue.fixversions.name}}",
"Original_estimate":"{{issue.originalestimate.sum}}"
{{/}}

[Bill Sheboy]

Please re-read my suggestion and that article.  Your rule should look like this:

• trigger: scheduled with no JQL included in the trigger
• branch: on JQL to select your issues, and enable the bulk-handling option
  • action: send email, and it should reference the {{issues}} smart value.  Please note that smart value is plural and not the singular {{issue}} one.

[tatevikalaverdyan]

Thank you, Can you please help me with email content. Currectly I receive empty mails. Content is as stated in the article.

{{#issues}}
{{issue.timetracking.originalEstimate}}

{{/}}

Is there anything wrong?

[Bill Sheboy]

When inside of an iterator, such as {{#issues}}...{{/}} the issue prefix is not used; the scope is the iterator.

For example, this would list the issues and their original estimates:

{{#issues}}
* {{key}} -- {{timetracking.orginalEstimate}}
{{/}}

This would sum the values, without the iterator:

{{issues.timetracking.originalEstimateSeconds.sum}}

[tatevikalaverdyan]

!!! Second option worked, thank you