EOFY report

[Ayliffe, Samantha]

Hi. I am new to Jira reporting and wondering what is the best way to pull an EOFY report for all closed tickets from all sprints throughout that time. I am wanting to then export to Google Sheets to pull down to a user level.

[Aron Gombas _Midori_]

Based on your non-detailed requirements, it should be fairly easy.

1) First, you should run a JQL search like this:

resolved >= startOfYear("-1") and resolved >= endOfYear("-1") order by resolved asc

It will return all issues solved in the last calendar year, sorted by resolution date ascending.

2) Then, in the Issue Navigator, choose those columns you want to include in your report. (It sounds like Assignee should be one of them).

3) Then export it to a standard XLSX file with the Better Excel Exporter. Use the Current fields export type.

4) Finally import the file to Google Sheets. As the data values are precisely there, you can now create a pivot table.

(Discl. the app mentioned is a supported and paid app developed by my team.)