Backlog health: count of issues without story points

Hi @viviane,

To get a count of issues without story points, you can build a calculation as a count of all Issues created minus issues with story points (for it you may use a hidden measure Issues with Story Points created):

[Measures].[Issues created] - [Measures].[Issues with Story Points created]

Similarly, you can get a count of resolved issues without story points, this time using measures Issues resolved, and hidden measure Issues with Story Points resolved:

[Measures].[Issues resolved] - [Measures].[Issues with Story Points resolved]

Based on those calculations and using the formula of Open issues as a template, you may build “Open issues without Story Points” like this

CASE WHEN [Issue].CurrentMember.Level.Name <> 'Issue' THEN
  Cache(
    NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),
      Cache(
        ([Measures].[Issues created] - [Measures].[Issues with Story Points created])
        - ([Measures].[Issues resolved] - [Measures].[Issues with Story Points resolved]) )
    ))
    + ([Measures].[Issues created] - [Measures].[Issues with Story Points created])
    - ([Measures].[Issues resolved]- [Measures].[Issues with Story Points resolved])
  )
WHEN [Time].CurrentHierarchyMember IS [Time].CurrentHierarchy.DefaultMember
THEN 
  ([Measures].[Issues created] - [Measures].[Issues with Story Points created])
  - ([Measures].[Issues resolved] - [Measures].[Issues with Story Points resolved])
ELSE
  -- optimized formula for drill through Issue
  NonZero(IIF(
      DateBeforePeriodEnd(
        [Issue].CurrentMember.get('Created at'),
        [Time].CurrentHierarchyMember) AND
      NOT DateBeforePeriodEnd(
        [Issue].CurrentMember.get('Resolved at'),
        [Time].CurrentHierarchyMember) AND
      IsEmpty([Issue].CurrentHierarchyMember.get('Story Points')),
    ([Time].CurrentHierarchy.DefaultMember,
      [Measures].[Issues created]),
    0
  ))
END

Best,
Zane / support@eazyBI.com

1 Like