Consolidated report for versions across projects

Question

Hi,

I am working on a two dimensional report that lists Users on on the Y axis and Fix Version on X axis. I am pulling out report for ALL JIRA projects.

We have created same version in different projects so that we can get a consolidated version wise report. So version 3.0 will be there in ALL JIRA projects.

EXPECTATION

1.02.03.0User 1025User 2200User 3121User 4203

In the above table: User 1 is working on two versions (2.0 and 3.0) and 7 Epics (2+5) across versions. The 5 Epics for version 3.0 are in different JIRA projects (2 in Project A and 3 in Project B) .

ACTUAL Result

1.02.03.03.0User 10223User 22000User 31210User 42012

If you see, 2 columns have been created for the same version 3.0 to show Epic count in two different projects.

Need help to create a report where I get consolidated column of a version (like I have in EXPECTATION section).

Regards,

Sarang

Sarang Chitre · Answer

Thanks Nic.

Is there any way to consolidate into one column.?

Sarang Chitre · Answer

I am using the below query:

project in (CS, IG) AND issuetype = Epic AND fixVersion IN (1.0,2.0,3.0) ORDER BY updated DESC

Nic Brough -Adaptavist- · Answer

That's correct behaviour.

Version 3.0 in project 1 is a totally separate version to version 3.0 in project 2.  Versions belong to projects, they're not global.  There are requests for shared global versions, but they're not implemented yet.