Leadtime not accounting time spent in backlog

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!


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.

[Measures].[Transition from status last date],
[Transition Status].[Backlog],
[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