Report showing all epics with user story status

I'm looking for a way to create an overview report where I can list all epics planned for a release with user story status included. The report should be possible to export to different formats, html for easy sharing and excel for further processing like adding risk assessments etc.

Example:

Epics valid for release 1

----

My first epic

User story X Done

User story Y In progress

My second epic

User story A Done

User story B Done

My third epic

User story L Todo

User story K Todo

Today I'm solving this with plain JIRA and Excel, is evaluating Greenhooper but can't find a way to do this.

(Plain JIRA is adding my own user-story issue type plus an epic project to get the epic->user-story->subtask hierarchy, works fine)

Any ideas?

Thanks

2 answers

1 accepted

2 votes

Johan, Structure plugin can build a hierarchy based on your Epic-Story relationships and export it to Excel.

  1. Create a structure (or use the initially created "Global Structure")
  2. Use Manage Structure page, locate your structure and use "Import" action. Import from "Filter", and use the same filter that defines your Agile board. This will populate the initially empty structure with the issues you have in GreenHopper, but the list will be flat.
  3. Now to get the hierarchy, use "Import" again, and select "GreenHopper". Select applicable projects, specify "Epic Field" to be "Scrum Board Epics". Don't select any Rank field. Run import and you'll have the issues in Structure rearranged as the hierarchy.
  4. Open Structure board and configure grid columns, then press Excel button. You'll get an Excel file with those columns and the hierarchy.

You can also configure the synchronizers to automatically maintain the structure in actual state.

More information in the docs:

Excel export: https://wiki.almworks.com/x/G4KF

Import and synchronization: https://wiki.almworks.com/x/hQBg

Hope this helps!
Igor

Disclosure: I work for the company behind Structure plugin

I second the recommendation for Structure - this plugin is awesome. :)

The Links Hierachy Structure plug-in can provide that report:

https://marketplace.atlassian.com/1211022

1. Create a filter to get all the issues with type = Epic

2. Run the Filter Hiearchy Structure Report and select the filter create above

3. Set the max depth of the structure to 1 and apply any required extra filter until you get just the information you what are looking for.

4. Export to Excel

Or you might create a Traceability Matrix Report to view Epics vs Stories in a matrix view (no export to Excel currently supported)



Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

456 views 1 15
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot