Issues in X Status by Month


Í´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?

Hi @dacosta
Welcome to eazyBI community!

You are on the right track - only, instead of Transitions to status, use Transitions to status issues count measure (find in Measures under “Distinct issues count” ).
Read more:

Ilze /