Create a Percent Complete Off of Children Issues

[Stephen Higgins]

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.

[Stephen Higgins · Accepted solution]

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]

Hello, 

Where do you use this formula in Jira? Thanks

[Stephen Higgins]

@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.