Epic Completion % not updating in custom field

[Siva Muthusamy]

Hi All,

I followed the steps provided in the Atlassian support article (Display Epic completion percentage on Jira Dashboard | Jira and Jira Service Management | Atlassian Support) Display Epic Completion Percentage on Jira Dashboard to create an automation rule in Jira Cloud that updates the Epic Completion % based on the status of its child work items. However, the Epic Completion % is still not displaying as expected.

Could you please advise on what might be missing or how to resolve this issue?

Thanks in advance!

Thank you!

[Marc - Devoteam · Accepted solution]

Hi @Siva Muthusamy 

Welcome to the community.

Does an Epic contain issues from multiple projects, if so does the automation rule scope has been set to the relevant projects?

[Siva Muthusamy]

Epics contains child work items from 1 project only.

[Marc - Devoteam]

Hi @Siva Muthusamy 

Show you automation rule  please, provide also the information of the steps.

Are the child items in status "Done" (green) and have they been set with a resolution.

On the board you are using is the "Done" status in the last column of the kanban/scrum board board?

[Siva Muthusamy]

Automation rule:

Work item transitioned:

To Status: Done

Add Conditions to Trigger - JQL Condition: hierarchyLevel = 0 AND Parent is not Empty

Lookup Work Items - JQL: Parent = {{issue.epic.key}}

Create Variable - Variable name: varTotalCountSmart , Smart value: {{lookupIssues.size|0}}

Lookup Work Items - JQL: Parent = {{issue.epic.key}} AND status = Done

Create Variable - Variable name: varDoneCount , Smart value:  {{lookupIssues.size|0}}

Branch
For: Parent, Rule  restricted to Projects : XYZ Jira project

Create Variable - Variable name: varEpicCompletion , Smart value:  {{#=}}{{varDoneCount.asNumber}}/{{varTotalCountSmart.asNumber}}* 100 {{/}}

Edit work Item - Epic Completion (Custom Jira field created - Epic) - {{varEpicCompletion.left(5)}}

On the board - Done / Cancelled status is the last column

Child work items in status "Done" (green) and set with a resolution

[Marc - Devoteam]

Hi @Siva Muthusamy 

So the rule is working, as it seems, but hat is your expectation.

The outcome should be a number in the field Epic Completion, isn't this the case?

[Siva Muthusamy]

That's correct

[Bill Sheboy]

Hi @Siva Muthusamy 

If you are using Jira Cloud, that article is out of date: rather than using the sunset epic smart value, your rule should use the parent one in the JQL.  For example:

parent = {{issue.parent.key}}

Next, that article's guidance is incorrect / unhelpful in suggesting the use of the left() function to get percentage to 2 decimal places.  Instead, please use the ROUND() function in the math expression:

{{#=}}ROUND( {{varDoneCount}} / {{varTotalCountSmart}} * 100, 2){{/}}

Finally, when a rule is not working as expected, please post actual images of:

• the complete rule in a single image for continuity
• the rule actions not working as expected
• the audit log details showing the rule execution, with all of the areas expanded

Kind regards,
Bill

[Siva Muthusamy]

Thank you @Bill Sheboy 

[Siva Muthusamy]

I am able to get the results as expected. Thanks @Bill Sheboy