Is there an easy way to view a list of epics and the number of user stories in each epic?

[JB Barnes]

Hi! I'd like to view a list of closed epics and how many user stories and/or a sum of their story points. We are implementing T-Shirt Size Estimation and would like to go back one Q and update epics for a rough understanding of size. I can't seem to figure out how to display (in a list) the story count or the story point sum. This would be really helpful. I can use epic sum up to do this, but I would have to link all the epics to a master epic.

[Trudy Claspill · Accepted solution]

Hello @JB Barnes 

Are the issues in a Company Managed project or a Team Managed project?

Can you create a static list of the Epics you want to include?

Jira does not store child issue count or sum of child issue points in Epics. It also does not provide a native method for you to get a list of Epics and their Child Issues based on using a filter to get the Epics. There are third party apps that would enable you to get a list of child issues based on a filter for retrieving the list of Epics.

If your issues are in a Company Managed project, and if you can generate a static list of the Epics you want to include, then you can create a filter like this:

"Epic Link" in (<comma separated list of Epic issue keys>)

That will give you a list of all the child issues.

In a Dashboard you can use the Issue Statistics gadget to group those child issues by their parent Epic.

The result will show you the count of issues per Epic.

You can do the same with the Pie Chart gadget, but that is limited to showing the top 9 with all others clumped under Other.

You could create an Automation Rule to go through the Epics and calculate the number of child issues and sum up their story points and store each of those in custom fields in the parent Epic. Then you could use the Filter Results gadget to display a list of the Epics with those two additional fields.

There are other options available if you are interested in acquiring a third party app.

[JB Barnes]

This is really helpful! Thank you so much!

[Sujala]

Hi @Trudy Claspill When I try to use the Epic Link, it shows up as Irrelevant.

Any idea why? I have double - checked all the user stories have Epics linked to them, or atleast most of them.

[Trudy Claspill]

Hello @Sujala 

Welcome to the Atlassian community.

Are you working with issues in a Team Managed project or a Company Managed project?

Using Epic Link doesn't work for a Team Managed project because that type of project doesn't use the Epic Link field to record the parent Epic of an issue. Team Managed projects use the Parent field for that purpose, and that fields is not one that is available in the Pie Chart gadget.

[Sujala]

Thats a shame. We are on Team based projects

[Marlene Kegel - codefortynine]

Hi @JB Barnes,

I am Marlene from codefortynine. 

If you want to sum up story points or any other number field, you can check out our app Quick Filters for Jira Dashboards.

Our app comes with a list of gadgets, which resemble the Jira standard gadgets, but with advanced functionality. 

It is possible to sum up story points with the following Quick gadgets:

• Quick Two Dimensional Filter Statistics
• Quick Issue Statistics
• Quick Pie Chart

 You can some features of our app without installation on our demo dashboards.