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

rose ABBL_f6tx87

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 P Claspill

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.