Issue Estimation Accuracy

Questions & Answers
1

Hi

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
2

Hi,

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:

NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
Not IsEmpty([Issue].CurrentHierarchyMember.get('Resolved at'))
AND
[Measures].[Hours spent]>0
AND
[Measures].[Original estimated hours]>0
)
)
)

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

Martins / eazyBI support