Get team backlog issues (not sprint backlog)

[Anton_Kruglikov]

Hello,

I’d like to get know if it’s possible to get issues from Team Backlog (not Sprint Backlog)?
We have the following structure:
One Jira Project for all teams, but each team has their own board. So, I’d like to see a number of issues in backlog per status for each team.

Thanks in advance.

[martins.vanags]

Hello @Anton_Kruglikov

From your described use-case it seems you could be using “Kanban boards”

The issues related to the Kanban board can be reported in eazyBI depending on how your Kanban board is configured (note that you can base the Kanban board on a project or your custom filter). You need to apply the same filtering in your report to show the report for the Kanban board in eazyBI.

If that is not the case, please share more details on the criteria you use in Jira to enter teams boards.

Martins / eazyBI support team

[Anton_Kruglikov]

Sorry, but not, it’s about Scrum board.

Sorry for bad explanation, I will describe more detail.

In Jira project we have field like ‘Team’ - it’s a drop-down, where we have list of teams: Team_1, Team_2 etc…
Each team board has the following configuration: project = Project_1 and Team = Team_1, project = Project_1 and Team = Team 2 . …

Then, each board contains backlog and sprints. Here is screenshot example:

So, what information we’d like to see is ‘Issues of Teams, which are not in Sprint (or Active Sprint), but in Backlog’. And then some additional info like ‘statuses of these issues’ etc.

[martins.vanags]

Hi,

Could you share an image where you enter the “Team” field?
Is it issue-level field in Jira that you use in issue screen?

Martins / eazyBI

[Anton_Kruglikov]

[martins.vanags]

@Anton_Kruglikov
Make sure you import “Team” as separate dimension

Then follow this community post to calculate “Backlog issues” just use “Issues created” as a base measure in your formula.

How to generate report of Backlog % for a particular sprint?

eazyBI does not import information about Backlog as we import only information stored directly in Issues. Jira stores only case when any issue is added to a particular sprint. eazyBI stores Backlog of all boards/sprints together, under (no board) member. Jira detects backlog by request for each Board using JQL query. You can check out Board JQL filter in Jira and then use MDX functions to apply it in eazyBI. In many cases, Board is related to one Project (one Team, etc.). I will use an exampl…

Martins

[Anton_Kruglikov]

Thanks @martins.vanags,

I tried and did it, based on this article, but what the issue I came to is that in this case I cannot know the average velocity of the team, because ‘Team’ dimension doesn’t know anything about sprints.
That’s why I wanted to build it, based on ‘Sprint’.

Now I have 2 separate charts - one with ‘Backlog readiness’ (by ‘Team’), second - ‘Average Velocity’ (by ‘Sprint’).

Maybe you can suggest me something to merge this data in one chart?

Thanks in advance.