Track Historical Status each Sprint

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!

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

      ([Measures].[Transition to status first date],
      [Transition Status].[Status C],
      [Measures].[Sprint start date],
      [Measures].[Sprint end date]
  ([Measures].[Transitions to status issues count],
  [Transition Status].[Status C],

Gerda //