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

Questions & Answers
2

Hi @Philippe_Puy,

Welcome to eazyBI community :slight_smile:

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].[Transition from status first date],
    [Transition Status].[Open],
    [Time].CurrentHierarchy.DefaultMember
  ),
  [Time].CurrentHierarchyMember
)
),
DateDiffworkdays(
  (
    [Measures].[Transition to status first date],
    [Transition Status].[Open],
    [Time].CurrentHierarchy.DefaultMember
  ),
    (
    [Measures].[Transition to status first date],
    [Transition Status].[Ongoing],
    [Time].CurrentHierarchy.DefaultMember
  )
)
)
)

Martins / eazyBI support