Unable to Display Epic and Linked User Stories Count in Dashboard

[Madhiseelan Ponnusamy]

Use Case#1:

I would like to have a Dashboard created , To Display the Epic & No of Linked Users Stories for the Epic. (Epic STATUS can be anything). 

I saved the search with Project and Epic. Used that while creating the Dashboard, but i couldn't find a way to Display Epic and Linked User Stories Count against each Epics.

Use Case#2

Similar to above. but an extended ask.

I would like to have a Dashboard created , To Display the Epic & No of Linked Users Stories for the Epic. Status of the User Stories. For Example: 

Epic 1 ----> 3 User Stories --> 2 Closed --> 1 In Progress

Epic 2 ----> 10 User Stories --> 7 Closed --> 3 In Progress

Unable to generate to create a dashboard with this way. Please advise. 

[David Friedrich · Accepted solution]

Hi @Madhiseelan Ponnusamy , welcome to the Atlassian Community!

I can only offer a solution for use case #1 I'm afraid. Use case #2 IMHO is not possible without any apps.

So for #1 just do this:

JQL of Filter: project = CMS AND issuetype in (Story) ORDER BY Rank ASC

Hope that helps!

----------

EDIT

Maybe this would be the solution for your use case #2, not entirely sure though:

Same filter JQL

[Madhiseelan Ponnusamy]

Hello David, This is exactly what i wanted. Works like a charm. Thank you so much. 

[Danut M _StonikByte_]

Hi @Madhiseelan Ponnusamy,

Try the Work Breakdown Structure (WBS) gadget offered by our Great Gadgets app. It can display the epics from a filter, along with their stories (and subtasks) in a tree structure (Epics > Stories > SubTasks), thus giving you a quick overview about the work and progress.

To display only the epics and stories, you need a filter or JQL like this:

parentEpic IN (Epic-1, Epic-2)

I hope this helps. 

Danut 

[Madhiseelan Ponnusamy]

Hi Danut M [StonikByte],

Amazing to see this in diff. perspective. For now, i need the counts alone in my dashboard, not everything on the tree level. but i would try this Great Gadgets, to see how it works. Thanks for your reply to my query. great share. 

[Hannes Obweger - JXL for Jira]

Hi @Madhiseelan Ponnusamy

I understand that you were able to solve your use case using the Two Dimensional Filter widget - well done!

Just for future reference: If you're open to solutions from the Atlassian Marketplace and may want even more flexibility, I think you'd like the app that my team and I are 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 support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. With these, you can build a report like the one below in just a couple of clicks:

This is really just one of a virtually infinite number of views you can construct in JXL.

Any questions just let me know,

Best,

Hannes