How to write a JQL filter to consolidate issue types over multiple teams?

[Nicole Kandora]

Hi All, 

we have one project but multiple teams. Each team is working in their own sprint (team A sprint 1, Team B sprint 1, etc.). 

I want to build a Gadget in a Dashboard that shows the current and all future sprints and the issue types: 

the y-axe should show the sprint (current and future sprints): 

• sprint 1 
• sprint 2 
• etc. 

the x-axe should show the issue types (consolidated number overall teams): team A sprint 1= 12 stories, team B sprint 1= 10 stories = 22 stories should be shown in the gadget for sprint 1) 

Can someone help me with the JQL filter? 

Thank you, 

Nicole

[Jack Brickey · Accepted solution]

Hi @Nicole Kandora , so you could use the two dimensional gadget to illustrate sprint vs.  type. It seems you simply need to exclude closed sprints so maybe this…

project = abc and Sprint not in closedSprints()

[Nicole Kandora]

Hi @Jack Brickey 

thanks for the quick response. This is a good idea. 

But how to count the backlog items together - I already have Sprint 1-6 planned for all teams. That means: 5 teams, each of them 6 sprints = 30 Sprints. When I use this I have a list of ALL sprints per team with the planned backlog items (issue types). 

I just want to show Sprint 1-6 for the whole project: 

Sprint 1 (for all 5 teams) -> all issue types consolidated for sprint 1 for 5 teams. Maybe this picture shows it better how I want to create the gadget: 

Is this possible? 

[Nic Brough -Adaptavist-]

There's no way you can do that, because it doesn't make any sense - your sprints are for different teams, so they are different objects.  Your "how I have it" is the right display of what is happening.

[Jack Brickey]

agree with Nic. You indicated you have different Sprints for each team so with only two axis you will see every sprint and every status. BTW, if you want to include backlog issues in the JQL where an issue has no sprint then add...

project = abc and Sprint not in closedSprints() or sprint is empty