Hi everyone,
I’m building a report and I want to count how many issues were re-assigned to the reporter of the issue, aka how many issues get re-assigned to their reporter.
EX: Tester1 enters Bug-123 and 2 weeks later Bug-123 gets transitioned to assignee Tester1.
On Row, I have my list of reporter,
In Measure, I have Transition to Assignee
Also in Column I have Assignee
And I’m stuck there. I don’t know how to specify that it should only count issues were the assignee it was transitioned to is the reporter.
Thanks to anyone who can help 
Hi @Marilou ,
You are on the right track by using the measure “Transitions to Assignee”. Please see its formula below:
( [Measures].[Transitions to], [Transition Field].[Assignee] )
To get the number of issues, I suggest using the “Transitions to issues count” measure instead of “Transitions to”.
Then, to get the assignee that is also the reporter, you can use the Reporter dimension current member in rows and get the user key. Then, with the GetMemberFromKey() function, you can retrieve the corresponding member in the Assignee dimension.
Try defining a new calculated measure with the formula below:
([Measures].[Transitions to issues count],
[Transition Field].[Assignee],
[Assignee].[User].GetMemberByKey(
[Reporter].CurrentMember.Key
))
And then you can have only the Reporter dimension in rows and the calculated measure. See the picture below:
See more details on the GetMemberByKey() function in the eazyBI documentation page - GetMemberByKey - eazyBI.
Best,
Roberts // support@eazybi.com
1 Like
