Days between two specific statuses

Hi everyone,
I’m trying to build a report that will show me all issues that meet certain labels (which is fine, I can do that), and then show, for each issue, the number of days between the statuses of In Progress and Ready for Release.
I’ve tried a number of things and it never seems to work, I always get syntax errors if I try a user-defined measure, and none of the existing measures seem to give me what I want.
Can anyone help?
Thanks

HI,

You can use something like this:

Custom Measure Transition to New Status

([Transition Status].[New],[Measures].[Transition to status first date])

Custom Measure Transition to Ready for Retest Status

([Transition Status].[Ready for Retest],[Measures].[Transition to status first date])

Then a Custom measure for New to Ready for Retest Time (Days)

DateDiffDays([Measures].[Transition to New Status],[Measures].[Transition to Ready for Retest Status])

Would just need to use the specific transitions you want.

The other item to consider is whether you want the first time it went to that status or the last since it may have transitioned more than one time.

If you want the first time it is [Measures].[Transition to status first date])

If you want the last time it is [Measures].[Transition to status last date])

Dennis

2 Likes

The solution proposed by @DennisT is right =) Measure “Transition to status first date” and function DateDiffDays() does the job.

More Community topics are exploring the same concept:

Best,
Zane / support@eazyBI.com