How can I automate Sprint Reports

[Alex_Palmer]

Hi guys,

Need some help on how to automate some Sprint reporting.

What I currently do:

- Complete Sprint
- Go to Issue Navigator for Completed Issues
- Go to Issue Navigator for Non Completed Issues
- Export both to Jira Google Sheets and then combine the two spreadsheets 
- I can then get the stats I need from there:

• How many issues were resolved during the sprint
• How many issues were not resolved during the sprint
• How much time was spent in hours overall during the sprint
• How many hours were serviced per customer (using Labels)

And update it into a separate Statistics Spreadsheet that I update each week.

Has anyone done anything similar and been able to automate this kind of report?

Thanks

Alex

[Jason Galea]

EazyBi would be the best solution. You can generate all kinds of reports based on sprints and also the requirements you listed. 

there is also an option to export the results in excel. 

cheers,
jason