How to add the story points of stories to the Epic?

[Hari Kotty]

Hi all,

I am trying to write a rule for the following requirement "summing up Story points of the stories to their linked Epics".

I have tried the following rule but its not working.

Looking forward to creating the rule.

Thanks in advance

Hari 

[Callum Carlile _Automation Consultants_ · Accepted solution]

Hi @Hari Kotty , welcome to the Community!

There is a similar automation rule set up in this question which uses a slightly different smart value used in the lookup, so it might be worth giving this a try. Hope this helps!

[Hari Kotty]

Thank you Callum.

[Bill Sheboy]

Hi @Hari Kotty -- Welcome to the Atlassian Community!

Your JQL on the Lookup Issues action is trying to match the wrong field.  Please try to match to the key from the epic (the branched issue)

issueType IN (Story) AND "Epic Link" = {{issue.key}}

Kind regards,
Bill

[Hari Kotty]

Thank you Bill.

I tried to match the key from the Epic, but I dont get the story points summation in EPIC.

Best regards

Hari

[Bill Sheboy]

Hi, Hari!

Are you using a company-managed or a team-managed project?

And, would you please post an image of your edit issue action?  That may reveal what it is not summing as you expect.

[Hari Kotty]

Hi Bill, 

I am using a team managed project.

I am attaching the image of the edit issue action, Please find the attached image.

Best regards,

Hari

[Bill Sheboy]

Thanks, and...

Company-managed projects use "Story points" and team-managed use "Story point estimate".  Please try using the other field in the edit with lookup issues.

And also...Smart values are case sensitive, and lookup issues uses camel-case like many of the values :

{{lookupIssues.Story point estimate.sum}}

[Hari Kotty]

Thank you Bill, 

I was unsure of team vs company managed projects, I do not see any Story point estimate, so I think I was wrong with team managed project. I have checked the smart values for case sensitive, and published the rule.

Still I dont get the summation of story points in EPIC. I am not sure whére I am doing wrong.

[Bill Sheboy]

Let's try some specific things to see if one of them reveals what is happening.

1. Is the rule triggering?  If so, please post an image of the audit log showing the details.
2. If not, please change your trigger to Field Value Changed on the Story Point Estimate field (not Story Points)
3. Next, please add an audit log entry *after* the lookup issues, writing this value:

Lookup Count = {{lookupIssues.size|0}}

This will show how many issues were returned, and to be summed up.