How can I retrieve all my previous Sprint goals?

[Alwin Brands]

I want to build up my teams dashboard. One of the returning questions is, how I can retrieve the Sprint goals in a specific year or period of time?

I have created those kind of queries in the past, but am afraind I might be confused as well with extended experience with Azure DevOps.

Can you help to with this question on JIRA queries and customized reporting (visibility).
Thanks 

[Alexey Pavlenko _App Developer_ · Accepted solution]

Hi @Alwin Brands ,

As far as I know, JIRA doesn't natively allow users to see sprint goals for all sprints throughout a year, but I know for sure that you can easily retrieve it with the app I developed - Multi-team Scrum Metrics & Retrospective.

You can select Period (X-Axis) = Year and after that use the drill-down feature to open sprints one by one within a certain month.

or you can choose Period (X-Axis) = Sprints and select the number of sprints you have in a year. In this case you will get this view:

Note that you can see several boards/teams at once in a single view.

Best regards,
Alexey

[Alwin Brands]

Hi Alexey, I will try to install this app/plugin. Not sure if I (as a simple user) are allowed to do this. We'll soon find out. Thank you.

[Alexey Pavlenko _App Developer_]

Hi @Alwin Brands ,

Yeah, you need to be an admin for that. Please note that this app is paid, as are many others. However, this app provides a lot of useful features - you can find them in the demo or on the marketplace page.

If you need any help - feel free to contact me.

Best regards,
Alexey

[Alwin Brands · Accepted solution]

Thanks everyone for your answers. Multiple answers makes sense, I think ;-) I will investigate and experiment the suggestions.

[Bill Sheboy · Accepted solution]

Hi @Alwin Brands -- Welcome to the Atlassian Community!

Do you mean the Sprint Goal entered for a Sprint from the Jira backlog?

If so, that information is only visible from the built-in reports, such as the Sprint Report, or on the board during the active Sprint.  To access the information for other purposes, one could use the REST API endpoint to get the Sprint data.

Kind regards,
Bill

[Alwin Brands]

Hi Bill, I got the same kind reply from one of my colleagues, who is quite succesful in reporting. He also suggested to create customized reports in Confluence.
Thanks for your reply. 

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Alwin Brands

that's an interest one. My first reaction was to not approach it via issues, but maybe via Jira's sprint report(s), but I can't actually find a good way to view this there either.

As an alternative, and following an issue-based approach, you should be able to solve your use case in the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with

• a range of advanced features, including support for issue grouping by any issue field(s), and
• a long list of so-called smart columns that aren’t natively available, including the issue's sprint goal (i.e., the sprint goal of the issue's latest sprint). 

With these, you can build a view like e.g. this in just a few clicks:

As every JXL sheet is powered by a JQL statement or saved filter, you have full control over which issues you want to include. I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to sum-ups or conditional formatting.

Any questions just let me know,

Best,

Hannes

[Alwin Brands]

Thanks Hannes, I will try this with help of my colleague who has 'development' experience for JIRA queries, reports and stuff. I'll get back to you if we get stuck ;-)

[Fabio Racobaldo _Herzum_ · Accepted solution]

Hi @Alwin Brands and welcome,

you can use the following jql to retrive specific sprint goal :

project = "YOUR_PROJECT_HERE" and sprint = "YOUR_SPRINT_NAME_HERE"

"Sprint goals in a specific year or period of time" is incorrect. Sprint is something that has internally a start date and end date so you should be able to search issues in a sprint without considering a period of time.

Hope this helps,

Fabio 

[Alwin Brands]

Thanks Fabio for your suggestion. I will test with help of a more experience JIRA Scrum Master your and the other options. To my understanding, the standard reports (on the dashboard) are quite limited. However on Confluence, what we use extensively for reporting as well, there is more flexibility.