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?
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])
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:
Zane / support@eazyBI.com
Hi @damianjmcgrath ,
I wanted to let you know that we have released eazyBI version 6.5 this summer. We included a feature to configure the Issue cycles in the eazyBI account import options: Issue cycles
Please see a list of all changes: Changelog - eazyBI for Jira
Gerda // support@eazyBI.com