Sprint Defect Leakage

Questions & Answers
3

Hi @lauma.cirule,

thanks for the answer, unfortunately I could not make it work based on your measure.

It seems to break with the FILTER statement matching for the sprint name. I reduced the query to this expression, which gives me no results:

NonZero(
  Count(
    DISTINCT(
      [Issue].[Issue].GetMembersByKeys( -- getMembersByKeys will get all Bug issues
        Generate( -- we generate list of the bug keys from issues completed in the sprint
          Filter(
            Descendants([Issue].CurrentMember, [Issue].[Issue]), -- find issues
            CoalesceEmpty([Measures].[Issue Sprints], '') -- that have ever been in the sprint
              MATCHES '.*(^|,)'||[Sprint].CurrentHierarchyMember.Name||'($|,).*'
                AND [Measures].[Sprint issues completed] > 0 -- and are completed in this sprint
          ),
          [Issue].CurrentHierarchyMember.getString('Bugs linked'), ","
        ) -- get their bug keys
      )
    )
  )  
)

If I remove the MATCH statement, at least I get results, of course not matching on a sprint basis.

Can you give me some more hints how to solve this?

Best regards,
Mirko