Agile reporting across multiple Jira Projects

Hi, 

I have few agile development teams that work on tasks for many biz projects (Many to Many). So every dev team have it own JIRA Project for the backlog.

It is possible to generate and agile report (like release burndown for example) that span across few JIRA Projects.

So for a particular biz effort we used a label (tag) for all the JIRA Stories/task , we would want to pull the burndown chart from JIRA projects A, B and C.

 

Thanks ,

Lior

 

 

 

 

 

 

 

2 answers

0 votes

You just need to include all your issues in the board filter.

Can you provide steps to create that report. On our JIRA intance when I navigate to an Agile board and select the Report tab I don't see an option to specify which issues are included in the report.

Lior

 

 

The reports report on the issues included in the board. There's no "specifiy issues" because it reports on the board.

How does this answer the question?

The question is simple: I want a chart that shows data from several projects. The answer is that a chart reports on a board, so if you want a chart telling you about several projects, include them in the board.

I get that, but I cannot get the report blueprint to accept a single JQL statement to include all projects. Thus, project = 'IIA' works fine. But I was only able to add additional projects to the report blueprint by using the JIRA/Issue filter from the Insert drop-down. And try as I might I cannot find the JQL syntax for All Projects.

I'm sorry, but that makes little sense. What do you mean by "report blueprint"? JIRA doesn't have those. It sounds like you are actually working in Confluence, and this question has nothing to do with Confluence, so you're asking in the wrong place. As for the JQL syntax for "all projects", I'll say it's not obvious, but it is simple. It's "". Or nothing. The point is to select "everything", so if you enter a query with no clauses to limit it, you get the lot.

Thanks for that. Tried it but I still cannot get a report to solve a very simple problem; give me a report that shows all projects. And yes, I'm in Confluence trying to get a JIRA issues report for all my projects using what I believe is called a blueprint. I'll keep thrashing away at it. The answer has to be in there somewhere.

JIRA doesn't have, or expose "all projects", it works with *issues*. So start there - does a filter for <nothing> return all the issues in JIRA? Can you use it in a "filter statistics" dashboard gadget to summarise the number of issues by project? Once you have that working, move into Confluence. Blueprints in Confluence are page/space creation wizards, not reporting functions, so I'm not sure why you're looking at those, but we can come back to that. Fire up a plain page and try the JIRA macros to see your filter - does that work?

project -> backlog -> board

Therefore, those kind of reports can easily made with SQL for JIRA (2.0+) as it supports the JIRA Software (Agile) REST API and it is possible to get the all the issues for any Agile board, backlog or even individual sprints and join the rest of the JIRA data like Story points, worklogs etc.

Furthermore, with the power of the SQL language you are able to filter and aggregate data in a really flexible and powerful way.

Hope this helps.

 

 

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

240 views 0 11
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot