How to find the sum of all issue types within a structure board?

[Deleted user]

Hi Everyone, I am looking for help in regards to adding up all issue types tied to epics as well as programs 

For example:

Program ABC has 4 separate jira epics linked with various amounts of issue types tied to the corresponding jira epic.  My manager would like to see the total number of issues tied that epic, total number of issues still OPEN or IN PROGRESS, and total issues closed. 

He does not want to SUM story points or use that data.  This is simply summing all issues tied to epics. 

Can anyone help me with the formula?  EXPR language formula examples doesnt give anything for this because I know its a little unique of a request. Ideally we would use story points but just asking for some guidance here.  thank you! 

[David Niro · Accepted solution]

Hello @[deleted] ,

David from ALM Works here.  

It sounds like you have a Structure hierarchy of Program > Epic > Story/Task and that you are looking to SUM the count of Open Story/Tasks at the Epic and then Program levels. 

We would also want to SUM the count of Closed Story/Task at the Epic and then Program levels in a separate column.  Is this correct?

If I do have it right, could you please share the issue types you use at the Story/Task level of the hierarchy?  

Looking forward to your response.

Best,
David

[Deleted user]

Hi David!  Thank you for your response.  YES this is correct.  We actual refer to our programs as "functional Epics" but other than that, this is exactly what I am looking for.  The issue types we currently have listed in our structure are: 

• Story
• Task
• Bug 
• Improvement 
• New Feature

thank you! 

[David Niro]

Hello @[deleted] ,

Thank you for the additional information!  We should be able to accomplish your goal with the formula below and choosing the Sum over sub-items option:

IF(
JQL{issuetype in (story,task,bug,improvement,newfeature)
AND Status != Closed};1)

Essentially it assigns a 1 to each of the issue types defined, that are not closed.  The Sum over sub-items option will then just count up how many 1s there are.

You may need to adjust the JQL portion to match the correct status(es) and/or issue types.  Additionally, you can create the "Closed" calculation by simply changing the != "closed" to = "closed" (or whatever status(es) indicate "closed").

Please let me know if this helps!

Best,
David

[Deleted user]

Thank you so much!  This worked!! 

[Mehmet A _Bloompeak_]

Hi @[deleted] ,

You can try Reports - Charts and Graphs for Jira app developed by our team to create table showing number of issues per epic and status as in the below screenshot.

You need to write your own JQL that lists issues under a specific program. Since program is not a default Jira issue type, I can not provide the exact jql for it. But maybe you already know how to write it.

Below you can see an article about creating custom reports, charts and graphs in Jira with our app.

How to Create Custom and Flexible Reports, Charts and Graphs in Jira

Here is our live demo dashboard where you can see and modify sample reports and play with them.

Hope it helps.