Calculate parent progress from child work item status in Jira Cloud
Platform Notice: Cloud Only - This article only applies to Atlassian products on the cloud platform.
Summary
Automate parent progress calculation in Jira Cloud using the Resolved status of child work items.
Solution
Use the following smart value to calculate the completion percentage of a parent issue based on the Resolved status of its linked child work items:
Percentage based on work-item count
{{#=}}ROUND((0+{{#lookupIssues}}{{#if(equals(status.statusCategory.name,"Done"))}}1+{{/}}{{/}}0)/{{lookupIssues.size|0}}*100,0){{/}}Percentage based on Story points
{{#=}}ROUND((0+{{#lookupIssues}}{{#if(equals(status.statusCategory.name,"Done"))}}{{Story points|0}}+{{/}}{{/}}0)/{{lookupIssues.Story points.sum|0}}*100,0){{/}}Details about the structure of smart value
lookupIssues is used to look up all of the work items.
Use Smart Value list filter to find the ones with a Status Category of Done; for those items, add a value followed by a plus sign.
The above value is wrapped in parentheses, so it can be divided by the total for the entire lookup result.
That value is then multiplied by 100 and rounded so it appears as a percentage, 0 to 100.
Finally, everything is wrapped in the math operators.
Note inside the rounding operation: an extra "0+" and a trailing "0" are added. This handles the case when the lookup returns nothing.
Was this helpful?