What is the best way to get average of completed issues in epic and display it into a field?

[Mkurama]

Hi, I just want to do these steps into my organization:

1-Get total number of issues in epic.

2-When any child-issue is done. number 1 will divide by all total number of child-issues.

3-Save the result into a field.

Note: Last step may happened again so, I want to get the old value and adding to the new value and saved into a field.

To summarize I want the percentage of the completed issues in one epic.

Thank you.

[Chris Buzon · Accepted solution]

You'll possibly need to write something to do this, either some API specific automation, or Jira automation.

Exactly how you do this is a personal choice, and depends on how your instance is set up and your understanding of the actual setup

- Lookup Issues action combined with Advanced Branching allows you to do a query, then store the query results in the {{lookupIssues}} smart value, then using the advanced branch action you manipulate the data (like get averages), then store that result in a variable (another action in Jira automation only -- accessible only in the current rule)

- Smart Values like {{lookupIssues.size}} can tell you how many tickets meet a specific JQL query  (like tickets in an epic that are in a specific status, etc), which can be valuable, especially if you don't want this rule to run every time something changes.
There are more methods you can use on the lookupIssues smart value as well.  The spelling of smart values is critical btw - and it's case sensitive.

- You'll do the math in the branches, then place that number in a custom field at the end.


It can be tricky to do this if this is your first rule. I can't really provide an exact answer here either, since it takes some trial and error to get things working.

[Mkurama]

Thank you Chris