EazyBI: Sum of issues between two projects

[Mateo Colombo]

Hi Community!

I need help in creating a specific report which I detail below:

I need to add from 2 different projects, the total amount of issues which are being worked on by one person of the team. 

There are a couple of difficulties as in the two projects issues are kind of different. This is what I need to add:

From Project A
Defects per Reporter
+
From Project B
Sub-task per Assignee

My end goal is to get a Table Report which shows all the names of the team members (which can be Assignees or Reporters dimension based on the Project) with their exact number of tickets (the sum stated on top)

In this case in Project A people in the team appear in the tickets as Reporters and in Project B the same people can appear as Assignees.

I am really struggling on how to approach this. Any help is appreciated!

Thanks!!

[Ilze Leite-Apine - eazyBI · Accepted solution]

Hi @Mateo Colombo 

If assignees and reporters are, in general, the same users (from eazyBI point of view: Assignee and Reporters both contain the same set of users), you may use one of the dimension, let's say, the Assignee dimension, in the report rows. Then create a measure that, for project A, finds, by user key, the same user from Reporter dimension and counts issues by it, while, for project B, counts issues by selected assignees.

The formula would be a sum of tuples; it would contain the function GetMemberByKey() to find users with the same name from Assignee and Reporter dimensions.

The formula for such a measure (if Assignee is chosen as the dimension in the report rows) would be the following:

 ([Measures].[Issues created],
  [Project].[Project A],
  [Issue Type].[Bug],
  [Reporter].[User].GetMemberByKey([Assignee].CurrentMember.Key),
  [Assignee].DefaultMember)
+
 ([Measures].[Issues created],
  [Project].[Project B],
  [Issue Type.By type].[Sub-Task])

You may also use Reporter dimension in the report rows as well; consequently, change the measure, so you would lookup assignee users for Project B instead:

 ([Measures].[Issues created],
  [Project].[Project A],
  [Issue Type].[Bug])
+
 ([Measures].[Issues created],
  [Project].[Project B],
  [Issue Type.By type].[Sub-Task],
  [Assignee].[User].GetMemberByKey([Reporter].CurrentMember.Key),
  [Reporter].DefaultMember)

Best,

Ilze, support@eazybi.com