How to export stories completed last sprint, sorted by epic to excel

[Patrick Sullivan]

I've been asked to create a presentation that shows the work completed in our previous sprint at are sprint review.

The ask is that it be separated by epic and I was wondering if there is a simple JQL inquiry that could do this, or a report that can be run?

I was thinking of exporting the stories to excel, then just copy and pasting them if I could get a good search query to do this.

[Trudy Claspill]

Hello @Patrick Sullivan 

Welcome to the Atlassian community.

There is no direct, simple query that will return "issues completed in sprint X". Issues can be assigned to multiple sprints over their lifecycle, and the definition of "completed" varies depending on the configuration of the scrum board. And there is no record in the issue that explicitly notes in which sprint a given issue was "completed".

There is the Sprint Report that shows all the issue completed within the sprint.

From there you can click the View in Issue Navigator link to see the results in an issue search screen.

You can modify the filter to sort the issues by their parent (Epic)

And you can use the Export Issues button at the top of the screen to export the data.

[Danut M _StonikByte_]

Hi @Patrick Sullivan,

A better alternative to manual processing in Excel would be a Jira dashboard showing the necessary info about the sprint. And you could share and visualize it with your team during the sprint review meeting.

Our Great Gadgets app offers some gadgets that can be of great help for you.  

For example, by using the Work Breakdown Structure (WBS) gadget you can display the issue from a filter and JQL in a hierarchical structure in form of Epic > Stories > Sub-Tasks along with their status.  

All you have to do is to configure the gadget with a JQL that returns the issues from your sprint: 

sprint = "My Sprint"

... and it will do the grouping for you. For the epics to be displayed, they must be returned by your filter. For this you can add the epics in the sprint or to extend the JQL to return also the epics 

sprint = "My Sprint" OR epic IN (Epic1, Epic2).

Another option would be to use the Sprint Burndown Burnup Chart gadget offered by the same app.

On its Data tab, this gadget display the issue from the sprint and the report can be exported in CSV so you can open it in Excel for further processing.

Find more about these gadgets (and the many others offered by the same app) in these articles:

• https://community.atlassian.com/t5/App-Central/8-gadgets-for-a-powerful-Scrum-dashboard-in-Jira/ba-p/1683063
• https://community.atlassian.com/t5/App-Central/How-to-track-scaled-agile-SAFe-projects-in-Jira-with-Great/ba-p/1929694

The app is free for less than 10 Jira users. Otherwise, you can start with 1-month free trial. If you have any questions, feel free to contact us at support@stonikbyte.com.

Hope this helps.

Danut