We want "Average age issue" for resolution as none

Questions & Answers
1

As of now we are using “average age days” (Pre-defined) for tracking open issues but our team has set the resolution as none, as a result we are not getting data
can anyone suggest the way to get data even for issues with resolution but status in open

2

Hi,

There seems to be no efficient way to reproduce the average age measure if you use the “None” resolution and treat such issues as unresolved. The average age measure uses the “Issues due” measure which is a standard eazyBI measure for counting unresolved issues (no resolution).

There can be workarounds with more complex custom calculations which might depend on the exact design of your report. The idea would be to use the Average function in eazyBI and iterate over all issues filtering unresolved or with resolution “none” and taking the average. The formula could be like this:

Avg(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    ([Measures].[Issues created],
     [Resolution].[(unresolved)])>0 OR
    ([Measures].[Issues created],
     [Resolution].[Done])>0
  ),
  DateDiffDays(
    [Measures].[Issue created date],
    Now()
  )
)

Kindly,
Janis, eazyBI support