the average difference between two steps

[mohiste]

Hello,

I want to calculate the time (delay) between two steps, and if there is a recurrence it will be the average

Delay in this example = DTetap (when LIBUO = De est Valideur and STATNOT = Submitted) + DTetap (when LIBUO = CNN and STATNOT = IN PROGRESS) /2

Delay  (in networkday)= 3+9 /2 = 6 days

I welcome every idea or help

thanks 

[Chanty4u]

try this

Avg(
NetworkDays(
Aggr(FirstSortedValue(DTetap, -DTetap), LIBUO, STATNOT),
Aggr(FirstSortedValue(DTetap, DTetap), LIBUO, STATNOT)
)
)