How to access historical data from Jira

[b_hassan21]

Hi Everyone,

I'm trying to create reports for my organization but they need historical data from sprints,epics , how can I get that data as once we close the sprint that data is not there anywhere to find.

Thanks for any guidance 

[Martial]

We ran into similar questions and wound up developing an external solution that runs daily Jira ticket data extracts and then allows us to run any over-time comparisons and/or graphics.

We needed this for various scope, progress and financial controls and couldn't find a way how Jira could support us out-of-the-box.

I have wondered whether there could be enough community interest to turn into an extension for the marketplace. Will do some review to see whether more of us have run into this.

[Yuliia_Borivets__SaaSJet_]

Hi @b_hassan21 

The velocity report is the first thing that came to mind if you're looking for sprint predictability report. Another one, that might be even more relevant in your case, is the Burnup report. Here you can choose any sprint and compare issues committed vs issues completed.

If you're looking for more historical details (like what changes were made to issues, by which user and when) you can check the Issue History add-on. My team has developed it as a retrospective journal for every past activity.

Let me know if you find any solution handy.

[b_hassan21]

Thanks, I already know these reports. I want to access that data and make Power BI report. How can I get that data. Like completed story points 

[Nic Brough -Adaptavist-]

Welcome to the Community!

As an issue tracker, Jira tracks all change on the issues, and that's where the data for historical changes on sprints, epics and everything else is kept.

So, the simple answer to "how can I get that data" is "look at the history for the issues".

But that's not a lot of help to you, I think.  Could you tell us what you are trying to report on in a bit more detail?  There are plenty of historical reporting options, but we cannot really point you to any that might be useful without knowing what reports you're trying to get to!

[b_hassan21]

I'm trying to generate sprint predictability report, issues committed vs issues completed. Problem is as we close sprint we can't get that data, or how to pull that. I even tried AIO reports and Jira Connector .

Thanks for your reply, looking forward to some kind of solution