Count issues with no story points (No register of improvements issuetype)

Questions & Answers
, ,
1

Hi community,

I’m dealing currently with a problem regarding the issuetypes and the total calculation of them.

I need to know the total amount of issues without story points, however, it doesn’t add the “Improvement” issue type as it only count the “story” type.

This is my measure code, do you know what may be happening?

NonZero(Count(
  Filter(
    Descendants([Issue].DefaultMember, [Issue].[Issue]),
    DateBeforePeriodEnd(
        [Issue].CurrentMember.get('Created at'),
        [Time].CurrentHierarchyMember) AND
    ([Measures].[Issues created],
      [Time].CurrentHierarchy.DefaultMember) >0
      AND NOT
      ([Measures].[Issues resolved],
      [Time].CurrentHierarchy.DefaultMember) >0
    AND
      IsEmpty([Measures].[Story Points history])
    )
  )
))

I already tested that my Source data importation has the improvements taken into account.

Many thanks

2

Hi @arilai

Welcome to the Community! :slight_smile:
This formula does not limit the selected issues by their type. Could it be the case that some of the selected Page filters in your report are limiting the output?

Additionally, you can check out the answers to these Community posts that are describing in detail how to count issues without story points:

Best regards,
Nauris / eazyBI support

1 Like