Overdue as Transition Status

Questions & Answers
1

Hello everyone,

i want to build an “overdue” report based on the issue history (the transition status history). I want to see for example how many issues were overdue 2 weeks ago, exactly on day X. And this for any given time. Any suggestion how to solve this problem? Is it possible to “calculate” an overdue transition status and use the “issue history” function?

i appreciate any help.

Lars

2

Hi Lars,

The overdue issues on the Time dimension you can calculate by the following measure:

nonzero(count(
  Filter(Descendants([Issue].Currentmember,[Issue].[Issue]),
     Datecompare(
      [Measures].[Issue due date],
      [Time].CurrentHierarchyMember.Startdate
    )<0
    and
    (isempty ([Measures].[Issue resolution date])
    or
     Datecompare(
      [Measures].[Issue resolution date],
      [Time].CurrentHierarchyMember.Startdate
    )>0      
    )
    and
    ([Measures].[Issues created],
     [Time].Currenthierarchy.DefaultMember)>0
  )
))

You can add the measure to the report with the Time dimension and see the overdue issues by the Time dimension day members.

Best regards,
Janis, eazyBI support