How can I get issue count & story point count for each Epic?

[rose ABBL]

Is there a way to take the JCL below and sum issue count & total story points for Component (Product) and also Epic?  if we could differentiate Done/Closed/Cancelled counts from all not-done, that would be even better.  perhaps there is another way to get these metrics?

project = "123" AND type not in (Epic, Task, Sub-task) ORDER BY component ASC, "Epic Link" ASC, status ASC

using  (v8.20.6#820006-sha1:60f1cbf:tlpajira-2) 

[Trudy Claspill · Accepted solution]

Hello @rose ABBL 

Welcome to the Atlassian community.

JQL does not provide summary data. It provides a list of matching issues. You have to use another tool to summarize data from the issues in the list.

For count of issues based on status you can use the Two Dimensional Filter Statistic Gadget, making Status one of the Axis. You could have multiple instances of the gadget where Component is the other axis for one, and Epic Link is the other axis for the other.

https://confluence.atlassian.com/adminjiraserver0820/using-dashboard-gadgets-1095776740.html

There is not a native gadget for summing up the Story Points in issues from a JQL results set, but I'm sure there are third party plugins you can adde to your Jira instance that would add that capability or gadget.

[RVS_Support]

Hi @rose ABBL 

Welcome to the community !! 

If you would be interested in a third party add-on, to roll-up time estimates and story points at each parent level, you can try out our app. The example below also shows the child issue count.

Agile Tools : Epic Tree, Links Tree, Time in Status & Worklogs

The app provides the following features.

Epic Hierarchy :- View/Manage roll up of time estimates for standard Jira hierarchy. Epic -> User Story/Task -> Subtask

Do try it out.

Disclaimer : We are the developers of this app