Hi @Vero ,
You can try to create a new calculated measure that will look for the number of hours spent where the currently selected assignee is also the one who logged the hours. Please have a look at the linked eazyBI community posts below:
Hi @Roberto_Zambrano ,
welcome to eazyBI community! GetMemberByKey() function and display their Hours spent with the following formula:
(
[Measures].[Hours spent],
[Logged by].[User].GetMemberByKey(
[Assignee].CurrentMember.Key
)
)
The report would look like thi…
Hi Alan,
You can find the same user as Assignee from the Logged by dimension with GetMemberByKey() function and display their Hours spent per issue with the following formula
(
[Measures].[Hours spent],
[Logged by].[User].GetMemberByKey(
[Assignee].CurrentMember.Key
)
)
You could then create the following report
[example_-_eazyBI]
Note that I have added Issues created filter greater than zero to display all issues of the assignee also getting the ones where nobody has logged any …
And also, a report from the eazyBI Demo account - 3 Assignee Hours - Issues - eazyBI Demo Training - eazyBI .
The eazyBI documentation has more details on creating calculated measures - Calculated measures and members .
Best,support@eazybi.com