how do i create a table with list of epics and the status of each user story under the epic.

Question

I would like to create a table which will list the epic (pulling data from a field) and the status of each user story as columns in one row. Both Epic and user stories have labels and components that can be used to filter out the required data. 
Epic1 - Req user story status - Build user story status - QA user story status - signoff status

Epic2 - Req user story status - Build user story status - QA user story status - signoff status

Epic3 - Req user story status - Build user story status - QA user story status - signoff status

etc.,

Liz A. · Answer

I am looking for a view like this. We have user stories for an Interface. The Labels indicate which deliverable it is (requirements signoff, build completion, testing completion, uat completion). I want to see the status of each deliverable for an interface in one view.

If you see the table below, it will show me, I have completed Requirements and build for Interface1 and Testing is in progress. I can also see 67% of the requirements is done for my interfaces. Build is at 33%.

I can write macros in excel but I will have to extract data from Jira and run macros everytime i want to see the status. Looks like JIra also has a limitation on the number of rows we can extract and so it will not work as data becomes huge.

TeamCustom Field ValueLabel1 (Reqt Signoff)Label2 (Build)Label3 (Testing)Label4 (UAT)Team AInterface1Done (13 Jun)Done (20 Jun)In Progress (27 Jun)To Do (4 Jul)Team AInterface2Done (13 Jun)In Progress (4 Jul)To Do (11 Jul)To Do (18 Jul)Team BInterface3In Progress (4 Jul)To Do (11 Jul)To Do (18 Jul)To Do (25 Jul) % Completion:67%33%0%0%

Danut M _StonikByte_ · Answer

Hi @Liz A.,

Welcome to the Atlassian Community!

You could try the List view available at the Jira project level. This can display items by their hierarchy, along with child items. It does not support JQL filtering, but it might be just enough for your needs.

An alternative solution would be to search on Atlassian Marketplace for an app that provides such view.

In case you want to try an app, our Great Gadgets app offers some gadgets that will help you solve the problem; they are highly configurable and felxible.

Work Breakdown Structure (WBS) gadget - displays the issues from a filter/JQL by their hierarchy along with their status.

All you have to do is to configure it with a filter/JQL that returns the epics and stories and it will do the grouping for you.

Pivot Table & Pivot Chart gadget lets you create a pivot table based on issues from a filter/JQL.

In this case you need to configure it with a JQL that returns the only the stories, and to display the Parent Epic, Key: Summary and Status fields, like this:

Hope this helps.

Danut.

David Freitez · Answer

Hi @Liz A.

Welcome to the community, regarding your request, do you have Plans on your Jira cloud instance?:

With this tool it would be feasible to create a Plan and have the list you mentioned and the filters.

Here is the documentation: Get started with plans

Kindly review my comment and let me know if you have further questions.

Regards,
David