Export issues of Project to Excel?

Markus September 20, 2018

We use a field we use to see how long it took an issue to travel from the status "Ready" to "Done". This works fine for each issue.

Now we want to calculate the average time for the project. Its obviously adding all the Benchmarks fields up and deviding them by the number of issues.

The best solution would be if we coul just export the isssues in the project to an excel file so that the the field with a benchmark has its own column, we do some excel magic and calculate the average performance and can create fancy charts.

Anyone knows how to do is? Basically exporting issues of an project to an excel file so that each fields for the issues has its own column.

Thanks.

1 answer

1 accepted

2 votes
Answer accepted
Steve Thornhill
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 20, 2018

When you perform a search for all issues in that project, the export option to excel will give you the option to export fields in view or all fields. These will be separate columns in the export.

Victor Mutambuki [Mumo Systems]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 20, 2018

Screen Shot 2018-09-20 at 6.32.44 AM.png

Markus,

Go to --> Issues --> Search for issues --> Enter your JQL --> Click on the Export button as shown on image.

Victor

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events