Total number of children (Stories) for each Epic in JIRA Structure

[Caleb Park]

Hi guys,

I need a column for the total number of children (Stories) for each Epic in my JIRA structure.

First of all, my structure looks like this:

For information, I added Group by Component/s in automation, so there are groups of Component/s under each Epic and Stories are placed under groups according to its Components.

What formula can I use to calculate the total number of Stories?

What I used to use for Story # before implementing groups of Components was: 

IF issuetype = "Epic":
SUM#children{IF issuetype = "story": 1}

But after implementing groups of Components, the formula is not working now.

Any solutions?

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello @Caleb Park 

Removing the #children modifier from the formula should help - then all sub-issues under each Epic will be considered. The #children modifier puts focus strictly on direct sub-issues of Epics which are folders in this case.

If you need help with the formula - please reach out to us at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Caleb Park]

Thank you, @Stepan Kholodov _Tempo_! It works perfectly.

[Caleb Park]

@Stepan Kholodov _Tempo_ 

One additional question!

What formula can I use for putting the # of Children of each Group??

[Caleb Park]

This is what I am trying to use in Formula: (I want the number of Children (Story and Task) for each Epic and group.