Number of unestimated issues of type story in project in time

Questions & Answers
,
2

eazyBI has several measures to count story points history over time. However, we do not have a default measure to count issues with no story points over time.

We have default measure (hidden) to count the current amount of issues with story points Issues with Story Points created and you can use subtraction to get a count without Story Points subtracting this measure from all Issues created.

However, you are asking for a historical measure here. You would like to use a calculation on issue level:

Sum(
  Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
 -- filter by open issues in period
    DateBeforePeriodEnd(
        [Issue].CurrentMember.get('Created at'),
        [Time].CurrentHierarchyMember) AND
    DateAfterPeriodEnd(
      [Issue].CurrentMember.get('Resolved at'),
      [Time].CurrentHierarchyMember) AND
-- filter by issue type
    [Measures].[Issue type] = "Story"  
    ), 
    CASE WHEN 
-- filter for issues with no story points in period
      CoalesceEmpty([Measures].[Story Points history],0) = 0
    THEN 
-- count of issues based on all filter criteria
     NonZero(([Measures].[Issues created count],
      [Time].CurrentHierarchy.DefaultMember))
    END
)

Daina / support@eazybi.com

Unestimated Issues in project prediction report