Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
Avg(
NetworkDays(
Aggr(FirstSortedValue(DTetap, -DTetap), LIBUO, STATNOT),
Aggr(FirstSortedValue(DTetap, DTetap), LIBUO, STATNOT)
)
)