Time between to actions

[Valerii_Sverdlik]

Hi Daina,

thank you for your reply. Seems like this post

Calculating average time in transition for only the first time this transition is done

Hi @Philippe_Puy, Welcome to eazyBI community In this case, the “average workdays” won’t fit your requirement as it would include all the transitions to particular status. You could try creating a new calculated measure using Descendants and measures “Transition to status first date” NonZero( Avg( Filter( Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]), ( [Measures].[Transitions from status], [Transition Status].[Open] )>0 AND DateInPeriod( ( [Measures].[…

does what I need, but I a little bit lost in syntax. How can I modify the formula in order to:

1. Measure the last transition to 1 of 2 statuses: Closed or Done
2. Taking into consideration that in EazyBI setup status Awaiting Deployment is also treated as Closed state, but transition to this status only in this case is a part of development cycle
3. And of course apply only to the issue in Closed or Done status