Could you tell me how I can create a report to see difference between Estimated and Logged time?

Hi, here!
Sorry for my question if it was before.
I have a project “A” and a task on it. A project manager adds an estimation - 3h. A developer works and logs 5h in the end of the work. He didn’t estimate correctly before. How can I see this difference in 2h? And on all the project?

Now I create a calculated member but I see that the result isn’t correct:

[Measures].[Original estimated hours],
[Issue Type].[Task] -
[Measures].[Hours spent].
[Issue Type].[Task]

Please, help me! I don’t understand my mistake.

Thanks

Hi.
To get the Orginal esitmated hours please use the below code
DefaultContext((
[Issue].currentmember,
[Assignee].CurrentMember,
[Measures].[Original estimated hours]
))

To get the total hours logged, please use the below code
Case
When
Not ISEMPTY([Measures].[Average Worklog Delay (Hours)])
then
[Measures].[Hours spent]
Else
Null
End

To get the difference between estimated hours and logged hours, Please use
[Measures].[Original estimated hours] - [Measures].[Hours spent]

Please let me know if this works

Thanks.

Hi, Ram.v!
Thank you so much for your help.

Вut unfortunately this calculation doesn’t work

CASE WHEN NOT ISEMPTY([Measures].[Average Worklog Delay (Hours)])
THEN [Measures].[Hours spent]
ELSE
NULL
END

Do you have any ideas how to sort it out?

Thanks!

Hi,

Try the following code with the tuples code:

(
[Measures].[Original estimated hours],
[Issue Type].[Task]
)
-
(
[Measures].[Hours spent],
[Issue Type].[Task]
)

Martins / eazyBI support