Calculate number of child issues per status category for an epic

flaimo

I have added three numeric custom fields to an epic:

• Derived: ToDo
• Derived: In Progress
• Derived: Done

I would like to create automation rules to calculate the total number of issues for each field based on the status category of the derived/child issues. One trigger would be whenever an issue is added/removed to the epic and the other one, when the status of one of the child issues changes.

I played around a bit, but couldn't get it to work. Any ideas?

nmenere

Hi,

In Jira Cloud we have recently introduced a "Lookup issues" action that allows you to lookup issues via JQL and then reference them later in the rule as a smart-value.

With this you could have a rule:

• When issue created
• Branch on Epic
  • Lookup issues where jql: "Epic link" = "{{issue.key}}" and statusCategory = new
  • Edit issue - set "Derived:ToDo" to {{lookupIssues.size}}

 

Does that work for you?

 

Cheers,
Nick Menere [Atlassian]