Using the name of a person for two different dimensions?

Questions & Answers
1

hello, i want to create a table in eazyBI that looks like the following:

image
image423×129 2.62 KB

however, the jira fields/dimensions i have to work with are the “assignee” (used for Issues Open) and “resolved by” (used for Issues Resolved). is there any way to get these as two columns in the same table? i know i could do this easily in excel but having the live numbers in eazyBI is better for my current situation.

2

Hi @clairenen,

I’ve had a similar issue previously where I was using Reporters in Row buut needed to count how many issues they had re-opened.

This is the formula EazyBI support gave me.

([Measures].[Transitions to status],
 [Transition].[Done => To Do],
 [Transition Author].[User].GetMemberByKey([Reporter].CurrentMember.Key),
[Reporter].DefaultMember)

In your case, with Assignees in rows, it would probably look something more like this

([Measures].[Issues Resolved],
 [Resolved By].[User].GetMemberByKey([Assignee].CurrentMember.Key),
[Assignee].DefaultMember)

Note: If an issue was resolved by someone that was never the assignee on an issue, their name will be missing from your list.

1 Like