Create a Percent Complete Off of Children Issues

Stephen Higgins May 5, 2020

I have seen different ScriptRunner scrips doing similar functions but unable to put all of the pieces together on this. I need to create a script that calculates the % of all "DONE" related issues that have a  "Child of" relationship to the parent issue. Any help would be greatly appreciated.

1 answer

1 accepted

0 votes
Answer accepted
Stephen Higgins June 11, 2020

I ended up using the "Calculated Number Field (by JWT) to complete this request. 

 

Sample expression:

(
(
count(filterByIssueType(filterByStatus(linkedIssues("parent of"), "approve,done"), "Audit")) +
count(filterByIssueType(filterByStatus(linkedIssues("parent of"), "to be released,production validation, done"), "Development, Export File Development")) +
count(filterByIssueType(filterByStatus(linkedIssues("parent of"), "done"), "Meeting, Requirements, Task, Sub-Task,Training"))
)
/
count(linkedIssues("parent of"))
)
*100

Justine Comtat
Contributor
December 9, 2021

Hello, 

Where do you use this formula in Jira? Thanks

Stephen Higgins December 9, 2021

@Justine Comtat I ended up leveraging a Calculated Number Field post function that comes with the Jira Workflow Toolbox add on. I put that on an any status to any status transition in the workflow that I can execute from different workflows based on their transitions being executed. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events