JQL: A Jira wide filter, that shows stories completed, by sprint, for each project, in a year?

[Benjamin Dains]

Firstly...

It was hard to fit the question in the question box above, so I'll give more information here, and try to communicate what I'm trying to do.

--

We are trying to build a report that shows every issue that was completed (resolved) in a years time-frame (think 1/1/2019 to 1/1/2020) by project (and we use projects as functional team areas). 

I know we can't mock it up like this in Jira, and I would probably use something like EasyBI or PowerBI to do this, but this is the end goal, and getting the data is the first step:

Yearly Summary of Completed Work

Project A

1. Sprint 1
   1. 30 stories planned, 10 completed.
      [List issues]
2. Sprint 2
   1. 10 stories planned, 15 completed.
      [List issues]
3. etc.

Project B

1. Sprint 1
   1. 24 stories planned, 7 completed.
      [List issues]
2. Sprint 2
   1. 10 stories planned, 15 completed.
      [List issues]
3. etc.

This report would continue and show every team's work from the previous year and their progress.

[Zane eazyBI Support · Accepted solution]

Hi @Benjamin Dains,

You may explore eazyBI capabilities on Agile and Sprint analytics in eazyBI Demo account:
https://eazybi.com/accounts/1000/dashboards/5956-sprints-overview

Note that you can see a list of issues behind the numbers by clicking on the chart and choosing to Drill through issues (see picture below).

Best,

Zane / support@eazyBI.com

[Benjamin Dains]

Hi @Zane eazyBI Support !

Thanks for the answer, this is helpful, we actually arrived at the same conclusion earlier this week, thank you for mentioning this. :)