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
Measures:
Calculated Member: Total Workdays in Transition Status
CASE WHEN [Measures].[Transitions from status] > 0 THEN
[Measures].[Workdays in transition status]
END
Transition Status Calculated Member: Days in Transition Statuses To Do to Final Review
Aggregate({
[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?