Dashboard - dynamic sprint dropdown

[Anthony Pugliese]

Hi,
bit new to the settings within Jira and have my own playpen trying to go through settings and structuring projects

i am looking to create a recurring dashboard that presents the health of the current/open sprint without having to change the sprint ID in my filter at the start of each sprint

is there a way to have a dynamic sprint field that drives the reports without the extra work needed?

[Walter Buggenhout · Accepted solution]

Hi @Anthony Pugliese,

You can always refer to sprints dynamically in JQL with the following keywords:

Sprint in OpenSprints()

 shows all issues in sprints that have started and are not completed yet

Sprint in FutureSprints()

 shows all issues in sprints that have been created on a board but are not started yet

Sprint in ClosedSprints()

 shows all issues in sprints that have been completed in the past.

Hope this helps!

[Anthony Pugliese]

@Walter Buggenhout thank you. not quite what i want but i may need to work around it

open sprint seems to bring up other sprints closed/completed so not sure what i am doing wrong here

[Walter Buggenhout]

It brings up all open sprints across your entire Jira instance. So you might need to restrict your filter to a limited set of projects.

On a side note, there is also a specific Sprint Health Gadget, which has predefined metrics on it. In there, you can specify what board you want to pick the data from and it allows you to automatically select the active sprint from that board:

That may be another option if you are happy with the information that is included in that gadget.