Working a SAFe implementation of which I’d like to acquire the first transition date from Product Backlog to Sprint Backlog. The result would be a more realistic representation of issue lead time, particularly if the issue spills over to one or more sprints. Utilizing this lead time (first transition to sprint backlog → last transition to done ) as a gauge-limit, and [measure].[progress days] (cycle time) as a gauge value is what I’d like to accomplish.
Such a predefined measure may be of benefit to others implementing SAFe.
This formula will return the date when the issue was first associated with a sprint. I’ve named this measure “Issue first date”
TimestampToDate(( [Measures].[Transition to first timestamp],
[Transition field].[Sprint] ))
This formula will return the date of the last time the issue status was set to "Done”. I’ve named this measure “Issue last date”
TimestampToDate(( [Measures].[Transition to last timestamp],
[Transition Status].[Done] ))
When you have created both measures, proceed with adding a new calculated measure to compare both dates by using DateDiffDays function.
DateDiffDays([Measures].[Issue first date],
[Measures].[Issue last date])
Using Issue Cycles measures, add the measure showing how many days the issue has spent in status “in Progress”.
You should now have two columns - Issue cycles measure and the measure created in step 2.
4) Switch to the Gauge chart, setting your limits as in the example below
Let me know if I missed something and if you have some further questions!