Get list of unestimated items per issue type

Questions & Answers
#1

Hi all,

I am trying to get a report on how many items are not estimated in my project per issue type; a pie chart which shows that out of the 100 unestimated issues, 44 are user stories, 30 tasks, etc. Practically, the JQL query for this would be:
project = xyz and issuetype in (Improvement, “User Story”, Task) and status not in (Closed, Resolved) and originalEstimate is EMPTY

I have tried several things without success. Same info I can get by using the above query or from Portfolio, but I would like to have it in eazyBi to keep all my reports in the same place.

I would appreciate any help.

Best regards,
Nikos

#2

Hi, @nikbats,

No default measure counts Issues with or without an Original estimate. You could create a custom calculated measure that sums the issues where the Original estimate is empty. Please try the following:

Sum(
  Filter(Descendants(
    [Issue].CurrentMember, [Issue].[Issue]
  ), 
  IsEmpty([Measures].[Original estimated hours])),
  [Measures].[Issues created]
)

Lauma / support@eazybi.com

Count of Open Issues without Original Estimated Hours