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]

[flaimo]

That sounds promising, but we are using Jira Server. Will this be available there too?

[nmenere]

Unfortunately this is a Cloud only feature with no plan to migrate to the Server.

[flaimo]

😞  Server users = 2nd class customers