In EazyBI how can I restrict the Issue dimension to only show issues that have been estimated?

[graemejohnson]

I need to report on Original Estimated Hours vs Hours Spent - to see in hindsight how accurate our estimates have been.

I have to show this at Project level, and then drilling through to issue level.

Not all of the issues in our projects get estimated, and I'm only interested in ones where 'Original Estimated Hours > 0' or where the issue has transitioned at least once through the 'Estimated' state.

I think I need to restrict my Issue dimension by having a calculated member to filter out any issues that do not meet the criteria - but I'm struggling to work out how to do that. 

I tried this calculated member, and it returns no members...

Aggregate(
 Filter(
 [Issue].Members,
 [Issue].CurrentMember.get('Original estimated hours') > 0 
 )
)

Please can someone help me?

[Mārtiņš Vanags]

Hi,

Perhaps you don't need to create calculated member at all in this case

You could set the filter on original estimated hours column while being at Project level and then drill into issues would not even show issues without original estimated hours.

See the attached gif.

Martins / eazyBI support