Issue Estimation Accuracy


I need to produce a report that shows on a project by project basis how accurate our estimates have been for issues we’ve closed over a given period

On an issue by issue basis I would derive the accuracy as the Original Estimated Hours - Hours Spent.

It only needs to count issues where where Original Estimated Hours > 0 and where Hours Spent > 0 and the issue has been closed.

I can get a report to work on an issue by issue level i.e. where the rows dimension is ‘Issue’ but I can’t seem to roll this up to ‘Project’ level.

Please can anyone help???

1 Like


In that case, you could create a new calculated member in “Measures” dimension to count resolved issues (with your conditions) on any level (not just Issue level).

Try this code:

Not IsEmpty([Issue].CurrentHierarchyMember.get('Resolved at'))
[Measures].[Hours spent]>0
[Measures].[Original estimated hours]>0

Then you could filter your report by this column (after you select this measure)

Martins / eazyBI support