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; } } }

Jira Automation: How to make Epic status change by percentage of completed stories of epic

Jonathan Chatfield

Hello,

I have automated the process of story's status automatically changed at a certain percent of completed of sub-tasks status to Done. I am now looking at automatically updating the epic status progress from the completion of percentage of the automated story status with Done to change the Epic status to In Progress then after all the automated stories statuses are in Done Status then put the Epic status to Done status as well. My To Do status category is Backlog.
This is a project plan so we are going to have every task be a sub-task and those tasks live in Stories then every story is under a umbrella of a epic. Here is a example of that setup!

I do not have the function LookupIssue and I have been told that I will need to do a process that uses REST API. I do not know much about this process but I am excited to hear from anyone out there! =D

Accepted answers

Bill Sheboy

Hi @Jonathan Chatfield

You describe your automation rules do not have the Lookup Issues action; thus I am guessing you have Jira Server, correct?

If so...

First thing, please write some JQL which returns the child (and grandchild) issues for an epic, without returning the epic itself.

Then your rule could use the Send Web Request action to call the REST API issue search with that JQL. Here is a how-to article for that technique and the issue search function documentation.

When you have the response, you could use math expressions and smart value, list filtering to get the percentage from the count "done" / total count.

Kind regards,
Bill

All comments

Dave Rosenlund (Trundl)

Hi, @Jonathan Chatfield. I'm not a developer myself, but I do have some getting-started tips for you:

I'm told Atlassian's documentation for REST APIs is very good.
Also, Atlassian has a dedicated developer community that you can join.

Hope it helps,

-dave

Bill Sheboy

Hi @Jonathan Chatfield

You describe your automation rules do not have the Lookup Issues action; thus I am guessing you have Jira Server, correct?

If so...

First thing, please write some JQL which returns the child (and grandchild) issues for an epic, without returning the epic itself.

Then your rule could use the Send Web Request action to call the REST API issue search with that JQL. Here is a how-to article for that technique and the issue search function documentation.

When you have the response, you could use math expressions and smart value, list filtering to get the percentage from the count "done" / total count.

Kind regards,
Bill

Jonathan Chatfield

Hello @Bill Sheboy

We have finally gotten a new version of Jira and we have lookup action and variables. Can you show me a pathway of how to make epics automatically update based off the percentage of Story's status marked Done.

Bill Sheboy

No problem; glad to help! FYI...I am using Jira Cloud so please verify / test to confirm this works for your version of Jira.

The technique below uses the math expressions and list filtering I noted earlier. Let's assume you want to update the percentage "Done" whenever the status of a child issue changes, and the percentage value will be stored in a custom field in the Epic. Please adjust accordingly if those assumptions are incorrect.

trigger: issue transitioned
condition: issue type is Story, Task, Bug, or any of the types you have as children of your Epic
branch: to Epic parent
- action: lookup issues, with JQL of: "Epic Link" = {{issue.key}}
- action: update the parent's custom field with the result of this expression

{{#=}}ROUND( ( 0{{#lookupIssues}}{{#if(equals(status.name,"Done"))}}+1{{/}}{{/}} ) / {{lookupIssues.size|0}} * 100, 0){{/}}

How that works...

while iterating over the issues in the lookup result
filter on the ones with a status of "Done", adding +1 for each of those
and wrapping that in parentheses with a default value of 0 at the front
divide that by the total count of issues in the lookup
multiply by 100 and ROUND to the percentage is a whole number
finally wrapping all of that in a math expression.

That percentage is by count. If instead you want the percentage based on Story Points, try this one:

{{#=}}ROUND( ( 0{{#lookupIssues}}{{#if(equals(status.name,"Done"))}}+{{Story points|0}}{{/}}{{/}} ) / {{lookupIssues.Story points.sum|0}} * 100, 0){{/}}

Jonathan Chatfield

Thank you for responding back to me! I am currently working on this and I will try what you are writing.

I do not want my team to be touching stories and above as we will only edit Sub-tasks. I have a automation that will automatically update stories from the percentage of Done statuses from Sub-Tasks.
Will this automation still be triggered if I put story if it didn't get triggered by me but by a automation?

Welcome!

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

Quick Links

Find more posts tagged with

rest-api

jira-core

automation