Í´m new to Eazy BI, and need advice on how to get the following metric.
I need to get the number of Issues that transition to a certain state per month. (Testing Completed status)
([Measures].[Transitions to status],
[Transition].[in UAT => Testing Completed])
My problem is that if an issue has made this transition several times, it adds the number of times, and I only need to know the last one.
Should I subtract the number of times it reaches Testing Completed status minus the number it comes out?