nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Dashboard two-dimension filter to only show active sprint ober multiple projects

Matthias Nickel

On my dashboard, I want a simple chart to show me the current status of the active sprint in multiple projects.

If I create a JQL filter with sprint in openSprints(), I will get all active sprints, but also the closed sprints if an issue couldn't be closed in that one and moved the active sprint.

How can I only see the open sprints.

Accepted answers

Matthias Nickel

Sprint is not EMPTY AND status != done AND Sprint not in futureSprints()

Gives all issues. Actually quite easy.

All comments

Jack Brickey

If you are trying to find all issues in active sprints the this JQL should give you that - Sprint in openSprints()

now keep in mind that if any of the issues in an active sprint were in previous sprints and unfinished in those now closed sprints they will still show in the opensprints() results.

Fazila Ashraf

@Matthias Nickel ,

Does "issue not in closedsprints() and issue in openSprints()" help?

Matthias Nickel

Sadly, that doesn't work. It filters all issues, which started in the previous sprint. So I don't see the anymore.

Jack Brickey

@Matthias Nickel does this not give you what you need? If not please explain your goals further. Please provide the filter you are using.

Matthias Nickel

I want to have a simple overview over all ongoing Sprints on the dashboard. I have multiple projects in parallel, which have all the same sprint window.

If I use the JQL opensprints(), i get the result like you mentioned. If I use "not in closedsprints()", it doesn't show all active issues.

This is suposed to be a management overview, so I have to keep it simple.

Matthias Nickel

Sprint is not EMPTY AND status != done AND Sprint not in futureSprints()

Gives all issues. Actually quite easy.

Jan Denny_7oo9t1

I'm guessing the problem here is the widget being used. Whenever I use the two-dimensional widget with Sprint as one of the dimensions, the widget lists all sprints that each issue was in - regardless of the filter criteria.

I suspect the only fix would be an option in the two-dimensional widget to include only the most recent (current or future) sprint.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

sprint

dashboard

open

two-dimensional-filter