nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get Completed story points, Story point progress in a CF on Epic using Automation jira

saikarthik.chidem

Accepted answers

All comments

Bill Sheboy

Hi @saikarthik.chidem -- Welcome to the Atlassian Community!

You may do this with custom fields and automation, using Lookup Issues and Created Variable. For example, if you wanted to do this for all non-done epics the flow of your rule would be something like this:

trigger: scheduled trigger with JQL to find all epics which are not done
action: lookup issues on JQL to find all children of the epic
action: create variable (e.g. named varTotalStoryPoints) for the child count as {{lookupIssues.Story Points.sum|0}} for a Company-Managed Project. If you are instead using a Team-Managed Project, use {{lookupIssues.Story point estimate.sum|0}}
action: lookup issues on JQL to find all completed children of the epic
action: create another variable (e.g. named varCompletedStoryPoints) for the child count as {{lookupIssues.Story Points.sum|0}} for a Company-Managed Project. If you are instead using a Team-Managed Project, use {{lookupIssues.Story point estimate.sum|0}}
action: edit your custom fields to store the results
- Note for the progress percentage, you will need to use a math expression as created variables cannot be used as parameters to functions.

Best regards,
Bill

Isabella Barbour

Hi @Bill Sheboy

I'm trying to do the same thing and was wondering if you could help further?

I get an error when trying to do:

action: lookup issues on JQL to find all completed children of the epic

This is my action:

"Epic Link" = {{issue.key}} AND status = Done

But I get message 'A search during custom value definition found no issues'

And secondly, do you know what the math expression would be? I am using this one below and I get a success message but no figure gets inserted into the field.

Any help would be greatly appreciated.

Thanks

Isabella

Bill Sheboy

Hi @Isabella Barbour

You may want to consider posting your own question (and linking to other posts) in the future. That will make the post visible to more people. Thanks!

Would you please post an image of your audit log, expanding the Show More section? That may provide more details of what is happening.

And, what is the JQL you are using in the scheduled trigger?

Okay, on to your specific questions...

For the error you are seeing for lookup issues, what type of project are you using: company-managed or team-managed? If this is team-managed, please test with "parent" rather than "Epic Link".

Regarding your expression with the created variables, those need to be converted to numbers first. And, the divide() function appears to do integer math, so try this instead:

{{#=}} {{StoryPointsCompleted.asNumber}} / {{TotalStoryPoints.asNumber}} {{/}}

This is just the division of the values. If you wanted a percentage, add a multiplier by 100

{{#=}} {{StoryPointsCompleted.asNumber}} / {{TotalStoryPoints.asNumber}} * 100 {{/}}

Kind regards,
Bill

Isabella Barbour

Hi @Bill Sheboy ,

Thanks very much for your reply. I will definitely post separately in the future.

I'm in a company managed project. Here is a snap of my audit log:

JIRA 4.PNG

The JQL for the schedule trigger is:

issuetype = Epic AND status not in ("Done")

Despite this ( 'A search during custom value definition found no issues') all the fields seems to be updating correctly. It looks like "Epic Link" = {{issue.key}} AND status = Done is the problem. But not 100% sure. I use this same lookup to get the story points completed sum in another rule I use, I get the same message but it is summing correctly.

The maths expression worked and I was able to add FLOOR to get the percentage to round down.

Kind regards

Isabella

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

automation