Rolling Issue transition status from date report

Questions & Answers
1

@gerda.grantina You’ve helped @Seth44 and I before so hoping you can help us again.

We are trying to measure the flow of requirements management, but only want to include “actively managed issues” based on our PI start dates. We have aggregated specific transition statuses in the to-do and In-progress status categories, and we have time members with our PI start date.

What we are hoping to achieve is a count of issues in each of our aggregated transition status measures ON a specific date(the PI start date) and that HAVE BEEN updated within 9 months of that date, effectively aging out issues that have been sitting in the backlog doing nothing for 9 months before the PI started.

We are really struggling with this one, but there has a to be a (probably simple) solution for this. Perhaps it is myopia.

Desired Output (column headers)
Program | PI | Backlog | Refinement | Ready

but only showing issues in those transition status aggregates that were updated within 9 months before the PI start date

2

Hi @nubz

Thanks for posting your question!

Please try defining a new calculated measure in the Measures dimension with the expression below.

When you have selected this measure in your report, then add the Transition Status in columns and select the member you aggregated (your backlog statuses). This will count issues in each status and that were updated within 270 days before the selected time (your PI start date member in the Time dimension).

Sum(
  Filter(
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    DateInPeriod(
      [Measures].[Issue updated date],
      [Time].CurrentHierarchyMember
    )
    OR
    (
      DateCompare(
        [Measures].[Issue updated date],
        [Time].CurrentHierarchyMember.StartDate
      ) < 0
      AND
      DateDiffDays(
        [Measures].[Issue updated date],
        [Time].CurrentHierarchyMember.StartDate
      ) <= 270
    )
  ),
  [Measures].[Issues history]
)

Best wishes,

Elita from support@eazybi.com