Epic and issue count report

[Archana Keswani]

I am looking for a report where I have specific epics and story count under that.  I need total Story count and completed numbers.  Tried 2 dimensional Filter Statistic. but My filter is not working there.  issuetype = Epic AND "Parent Link" in (ABC-1111, ABC-2222) when I add this filter to get me those epics for which I need issue count, its not bringing me any epics. can anyone help?

Thanks,

[Hannes Obweger - JXL for Jira]

Hi @Archana Keswani

I understand you want to get certain epics along with the stories of these epics, and then get the respective issue counts? If that's correct, I doubt that you'll be able to achieve this in "plain" Jira, since there it would require a "hierarchical" query, which isn't natively supported in JQL.

To fetch the relevant issues in JQL, I believe you'll need additional functions as provided by several apps from the Atlassian Marketplace. I've used JQL Search Extensions a few times and it works great.

Once you've fetched the relevant issues, I'm still not sure how you'd get to the respective counts - maybe this is possible in the filter statistics widget if you count your issues by the "Epic link" field.

Another option would be to go with a more dedicated solution from the Atlassian Marketplace. If that's an option for you, I believe your use case would be quite easy to do with the app that my team is working on; I'll provide more details below.

Hope this helps,

Best,

Hannes

[Hannes Obweger - JXL for Jira]

Just to expand on the last point: If you're open to solutions from the Atlassian Marketplace, I believe this would be easy to do with the app that my team is working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including the support for issue hierarchies, and sum-ups. With these, you can build a report like this in just a few clicks:



You can sum up any issue field, and configure different sum-up styles. JXL also supports any number of hierarchy levels, so you could easily include e.g. initiatives into your report. 

There may be other apps in the Marketplace that can help with this, too. You may already know that you can trial any app for free for 1 month, and depending on the size of your size, it may be free forever. So if an app is an option for your, perhaps try a few and see which works best for you.

Any questions just let me know,

Best,

Hannes