Atlympics - Automation - Calculate the sum of original estimate of all Epic's subissues

Alex Koxaras -Relational-

Hi all!

This is my repost of my original post, which you can read here:

This automation solves the problem of calculating the sum of the original estimate of all issue types of an epic, without the use of an addon. Keep in mind that I had 4 different issue types (standard tasks) from which I wanted to sum up all original estimates and not story points.

Rule

Below you will find my rule, which after testing it, it works like a charm:

So what the above rule does is that

• Step 1: It tracks changes on Time Tracking
• Step 2: Rule keeps going only if the trigger issue type is specific
• Step 3: Get the original estimate value of the trigger issue and copy it on the Story Point field
• Step 4: Create a branch for the parent of these issue types
• Step 5: Looks up to find all issues with the parent Epic Link
• Step 6: Sums up the story points of the Epic's children and copy it on the Original Estimate field

Rule Break Down

Below you will find each individual rule component.

Step 3

{{issue.fields.timetracking.originalEstimateSeconds.divide(60)}}

Step 5

{{lookupIssues.Story Points.sum}}

Ending Note

I though to end this article by presenting to you the pros and cons of this rule:

Pros

• It delivers and works!

Cons

• Uses an extra field (story points) to do the copy/paste thus,
• This rule takes 3 to 4 seconds in duration (which I think is significant)
• Makes Story Point field obsolete, since it is used in the calculation, thus,
• You can't use any chart that uses story point

Cheers,
Alex

Suvradip Paul

@Alex Koxaras -Relational- , thanks for sharing! Much appreciated. I think except the Story Point field as obsolete which might raise some concerns other cons might be acceptable.

Cheers

Suvradip