I’m looking for a calculated measure or a solution which allows me to look at the average delivery time of a ticket over time. I would like to show this metric by looking at the creation date of the tickets, to get a feeling if we’re progressing over time (Unfortunately, due to the nature of this project, the tickets don’t have a fix version or some kind of release indication).
e.g. Calculate the Average delivery time for all the tickets created in the month of August / September / …
Goal: we want to measure if some of the process changes are making the teams more efficient, hence the interest in looking at the creation date of the tickets - as it becomes easier to relate to the changes in the operating model.
Observed / assumed behaviour: when plotting the average delivery timeline over time, without a dedicated calculated measure, I think the tool will include all the tickets which are open for that period.
I’ve created the calculated measure as presented below - it has some additional filters which are less relevant for tis topic, but these are confirmed to be working in other reports. Furthermore, I have the calculation to give me the average delivery time (works well and has been validated)
NonZero(Avg( Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]), DateInPeriod( [Issue].CurrentMember.get('Created at'), [Time].CurrentHierarchyMember) AND ( [Measures].[Issue type] = "Technical Epic" OR [Measures].[Issue type] = "Technical Story" ) AND ([Measures].[Transitions to status issues count], [Transition Status].[Ready for Handover] )>0 --checks if issue went to In handover status ), [Measures].[CSA Total Idle and Progress] ))
The measure above gives me unexpected results, so not sure what the best implementation would be for such a metric.