Track Historical Status each Sprint

Questions & Answers
1

I’m on an agile team that works in 3 week sprints in Jira. Say our sprint board has 4 columns: Status A, Status B, Status C, and Status D.

I’m trying to create a report that shows the total count each day for when an issue gets moved into Status C for the first time. So if an issue is moved into Status C, and then moved out, and then moved back into Status C say 8 days later, I want the report to show when it was moved into Status C the first time around and ignore the 2nd time.

The purpose of this report is to keep track of the trend on when our issues are first hitting Status C sprint over sprint.

Thank you in advance!

2

Hi @salesi ,
Please try this formula to count first transitions to status “Status C” during a specific sprint:

Sum(
  Filter(
    DescendantsSet(
      [Issue].CurrentHierarchyMember, 
      [Issue].CurrentHierarchy.Levels("Issue")),
    DateBetween(
      ([Measures].[Transition to status first date],
      [Transition Status].[Status C],
      [Sprint].CurrentHierarchy.DefaultMember),
      [Measures].[Sprint start date],
      [Measures].[Sprint end date]
    )
  ),
  ([Measures].[Transitions to status issues count],
  [Transition Status].[Status C],
  [Time].CurrentHierarchy.DefaultMember)
)

best,
Gerda // support@eazybi.com