Exporting Data from Jira Agile

Is there a way to export data from Jira Agile?

I need to be able to display all Velocity and Burndown charts on one report. I can manage Burndown via the dashboard gadgets, but Velocity is proving elusive.

I've tried to export all issues from Jira into a spreadsheet and manage it from there, but info about sprint start dates/duration seems to be stored elsewhere.

Any suggestions for how I can either: a) embed muliple velocity reports in a single document (without copying and pasting each individual report); or b) export sprint start/end dates to a spreadsheet?

Thanks!

6 answers

1 accepted

1 vote
Accepted answer

Hello Matthew,

I'm afraid there is no way to export the data in that way right now. You can only gather the info from the selected board's reports (velocity and burndown).

From the looks of what you intend to do, I believe that could be a very specific job for our team of experts, who would be happy to help you out! :)

Best regards,

Benito Picarelli

Thanks for the swift response Benito - your definitive answer will save me hours of frustration!

Kind regards

Matt

Is there still no way to export agile data from ondemand to hosted?

An update to this request would be good. 

Seem's completely bizarre that we can't export data into excel! Really strange!!!!

Our apps provide the following exporting capabilities for Jira Agile (now Jira Software) data.

1. PDF View Plugin can export any issue, also from the backlog, from sprints, from Kanban / Scrum boards to custom PDF documents. Via scripting you should be able to do your own calculations. We even have an old template for team velocity reports that you could as starting point:

jira-burn-down-chart

2. The same app can export all Jira Software gadgets, so you can get burndown charts, sprint health or complete boards at a single click:

jira-dashboard-agile-sprint-report

 

3. Better Excel Plugin can export any issue (backlog, sprints, Kanban / Scrum boards contexts are fully supported) to custom Excel spreadsheets, if this is your preferred tool. You can use functions, formulas, charts on any Jira Software managed value (in this case, to get the Velocity chart):

 jira-agile-report-epic-pivot-chart

I am sure one of these 2 can solve your use case. 

(Disclaimer: these are paid and supported apps, and I am a developer.)

It just blows me away-- all of the ink dedicated to this one simple and fundamental ask, including all the gyrations we have to go through (thanks to those who've figured it out).  Just give me an export option for details in a Sprint report.  Please???  How difficult can this be?

True! 

Hi,

I am using Jira as a user in our sub-contractors account. The deal with the sub-contractor is about to expire and we'd like to have all our issues and agile board in our new account. Is there a way to get all the necessary data to the new account?

Thanks in advance!

Hi,

I am using Jira as a user in our sub-contractors account. The deal with the sub-contractor is about to expire and we'd like to have all our issues and agile board in our new account. Is there a way to get all the necessary data to the new account?

Thanks in advance!

0 votes
Jason Worley Atlassian Team Mar 27, 2015

You might want to take a look at these existing suggestions:

 

https://jira.atlassian.com/browse/GHS-8804 

https://jira.atlassian.com/browse/GHS-6135

 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,949 views 19 22
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