Count of issues that exist a defined amount of days from creation

Questions & Answers
2

Hi @J.E,

The solution from the post-Report on issues closed within number of days from creation - #2 by martins.vanags groups data by the measure “Issues created” that constantly growing with new issues and group issues by the creation date. Thus results for past periods are changeing whenevere some issue gets resolved.
You might want to use the measure “Issues resolved” so it would count the issue by the period of resolution and would not change data for past periods.

NonZero(Count(
  Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    Not IsEmpty([Measures].[Issue resolution date])
    AND
    [Measures].[Issues resolved] > 0
    AND
    Datediffdays(
      DateWithoutTime([Measures].[Issue created date]),
      DateWithoutTime([Measures].[Issue resolution date])
    )<=90
  )
))

You may consider another approach and use the “Resolution Interval” dimension to group issues by the time to resolve them. Here are described how to enable this dimension and specify the duration for each interval: Interval dimensions.

Best,
Zane / support@eazyBI.com