# Need to use Assignee and Logged by in the same report

**URL:** <https://community.eazybi.com/t/need-to-use-assignee-and-logged-by-in-the-same-report/4677>\
**Category:** Questions & Answers\
**Created:** [June 16, 2020, 8:58pm UTC](https://community.eazybi.com/t/need-to-use-assignee-and-logged-by-in-the-same-report/4677 "2020-06-16T20:58:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vero](https://community.eazybi.com/letter_avatar_proxy/v4/letter/v/e19b73/32.png) [@Vero](https://community.eazybi.com/u/Vero)\
**Post date:** [June 16, 2020, 8:58pm UTC](https://community.eazybi.com/t/need-to-use-assignee-and-logged-by-in-the-same-report/4677/1 "2020-06-16T20:58:49Z")

</div>

Hi,

I have this report

![2020-06-16_16-52-29](https://community.eazybi.com/uploads/default/original/2X/1/17c0d6a11ecac3b9c1457296589b889cf3d60f7e.jpeg)

The report is set to use Assignee as page.  
Original Estimated Hours History and Remaining Estimated Hours History will use the assignee  
but I need to see in the cumulative hours spent and hours spent the hours that has been logged by the same selected assignee. Actually the report display the hours spent for what is assigned to the selected assignee, but some work are logged by different person.

Is there a way to Filter the hours spent where the logged by = assignee ?

Thank you

---

<div class="post-metadata">

**Author:** ![roberts.cacus](https://community.eazybi.com/user_avatar/community.eazybi.com/roberts.cacus/32/637_2.png) [@roberts.cacus](https://community.eazybi.com/u/roberts.cacus)\
**Post date:** [July 6, 2020, 10:16am UTC](https://community.eazybi.com/t/need-to-use-assignee-and-logged-by-in-the-same-report/4677/2 "2020-07-06T10:16:36Z")

</div>

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:

> [@Original estimated hours vs hours spents](https://community.eazybi.com/t/original-estimated-hours-vs-hours-spents/3143/2):
>
> Hi @Roberto_Zambrano, welcome to eazyBI community! slight_smile You can create a report by using Assignee dimension in the rows, with this you will get original estimates per assignee. After that you can find the same user as Assignee from the Logged by dimension with [GetMemberByKey()](https://docs.eazybi.com/display/EAZYBI/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…

> [@Issues assigned but no hours spent](https://community.eazybi.com/t/issues-assigned-but-no-hours-spent/2220/2):
>
> Hi Alan, You can find the same user as Assignee from the Logged by dimension with [GetMemberByKey()](https://docs.eazybi.com/display/EAZYBI/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 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](https://eazybi.com/accounts/22010/cubes/Issues/reports/376181-3-assignee-hours).

The eazyBI documentation has more details on creating calculated measures - [Calculated measures and members](https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members).

Best,  
Roberts // [support@eazybi.com](mailto:support@eazybi.com)