Issue Backlog with weekly trend

Questions & Answers
1

Hello,

I am trying to build a report that shows the following
issue backlog showing issues open for

  • more than 1 week
  • more than 1 month
  • more than 3 months
    -> I got this far using aggregated calculated members in the time dimension

Now I want to show the trend per week, so showing the above numbers for CW1, CW2 etc.
Is it possible to show this? I know combining time in 2 dimensions is not possible but maybe someone has an idea?

Thanks!

2

Hi Alex,

for currently open issue age, I would suggest using Age dimension rather than calculated members in Time dimension. Read more about interval and age dimensions.

For Open issue age trend in time, there is one example report “Average age of open issues” that could be useful for you (there are no age intervals, rather average open issue age and trends over time).

To get intervals, you may create three new measures (in Measures, not in Time dimension) where you count open issues that are open more than 1 week, more than 1 month and more than 3 months at the end of each week.

The calculation example to count issues open more than 1 week (and less than month) at the end of each time period:

Count(
Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
  [Measures].[Open issues] > 0 
  and
CASE WHEN DateInPeriod(Now(), [Time].CurrentHierarchyMember)
THEN DateDiffDays([Issue].CurrentMember.get('Created at'),
  Now())>7 and 
  DateDiffDays([Issue].CurrentMember.get('Created at'),
  Now())<30
ELSE DateDiffDays([Issue].CurrentMember.get('Created at'),
  [Time].CurrentHierarchyMember.NextStartDate)>7 AND
  DateDiffDays([Issue].CurrentMember.get('Created at'),
  [Time].CurrentHierarchyMember.NextStartDate)<=30
END
)
)

In the same way, create the rest of the measures, just by changing the conditions.

Ilze, support@eazybi.com