Workdays between two transition statuses averaged by Sprint

Hi all,

I’m trying to pull together a report that displays average time between two statuses (and a breakout of time in each status as a bonus) per ticket in a Sprint, that rolls up into an average time per Sprint.

My current report has:
Pages: Issue Type
Rows: Sprint, Issue

Calculated Member: Total Workdays in Transition Status

CASE WHEN [Measures].[Transitions from status] > 0 THEN
  [Measures].[Workdays in transition status] 

Transition Status Calculated Member: Days in Transition Statuses To Do to Final Review

  [Transition Status].[To Do],
  [Transition Status].[Work in Process],
  [Transition Status].[In Review],All other statuses

The output is close, but I can’t seem to get the total days to average for the amount of issues being summed.

The end goal is total days from To Do (Accepted) to Release by ticket, averaged by Sprint. Another way I’ve attempted is a datediffdays between last time in To Do status to first time in Final Review, but I’m having issues averaging this by Sprint. Any ideas?

Hi Jonny,

You may want to check out the answer in another thread, they seem pretty similar: Average Workdays between two statuses by Sprint