Calculate Estimation accuracy but only on Closed an Resoved Issues

Questions & Answers
1

I need to calculate estimation Accuracy and do this with the following calculated Member:

CASE WHEN
[Measures].[Hours spent] IS EMPTY
OR [Measures].[Hours spent] <= 0
THEN
0
ELSE
([Measures].[Original estimated hours] - [Measures].[Hours spent])
/ [Measures].[Hours spent] * 100
END

The problem is, how do I restrict the evaluation to Issues only where the Status is Closed or Resolved?
If all status values are used, work log is not finished and calculation gives wrong values.

Any hints on this?
Thanks Max

2

Hi @maxweissboeck

Thanks for reaching out!

I would recommend updating to the latest eazyBI version 6.6. which introduced Time tracking measures that you can use in your use case: Time tracking measures

You can then use the already predefined “Hours spent resolved” and “Original estimated hours accuracy %” measures.

​Let me know if this fits your use case or if you have any additional questions on this!
​Best regards,
​Nauris \ eazyBI support