Leadtime not accounting time spent in backlog

Questions & Answers
,
1

Hi everyone.

I’m trying to come up with a measure that calculates leadtime not accounting time spent in Backlog (First status). Has anyone ever come across such issue?

I thought about using datediff inputing transition timestamp from status Backlog to any other status and resolved timestamp but I’m not so sure how to develop it, would anyone give me a hand on this?

Thank you so much!

2

@stefano.matos

See some demo reports with custom cycles here: Age, Lead, and Cycle Time - Jira Demo - eazyBI

You could try defining the cycle or manually calculate the difference in days using datediffdays() function.

DateDiffDays(
(
[Measures].[Transition from status last date],
[Transition Status].[Backlog],
[Time].Currenthierarchy.DefaultMember
),
[Measures].[Issue resolution date]
)

It will calculate the time it took from the last transition from Backlog (ever) until the resolution date.
And it will show results for issue-level report.

Martins / eazyBI support