Forum Discussion
Solved
Event duration
Hi all, I have a question, i have this table, and im trying to know how long spesific escalation was in each event type. For example- escalation 168 opened-->moved to on hold-->reopened---> moved...
Hi gkakun ,
You are correct, I have made the contrary logic how long does it take to get from the previous status.
Replace the calculations by:
Duration = DATEDIFF ( 'Table'[Date Time], CALCULATE ( MIN ( 'Table'[Date Time] ), FILTER ( ALL ( 'Table' ), 'Table'[EscalationID] = EARLIER ( 'Table'[EscalationID] ) && 'Table'[Date Time] > EARLIER ( 'Table'[Date Time] ) ) ), DAY ) + 1try if #"Added Index"[EscalationID]{[Index] + 1} = [EscalationID] then Duration.Days( ( #"Added Index"[Date Time]{[Index] + 1}) - [Date Time]) + 1 else null otherwise null
Hi Friend,
Thanks a lot for your help.
The logic is not working well. For example, escalation number 168 was on hold from Feb 8 until Feb 13 (on hold, and then reopened, 5 days), and then was o hold from Feb 14 until March 16, and then reopened, and closedf on March 23 (32 days). Overall 37 days and not 10
Hi gkakun ,
You are correct, I have made the contrary logic how long does it take to get from the previous status.
Replace the calculations by:
Duration =
DATEDIFF (
'Table'[Date Time],
CALCULATE (
MIN ( 'Table'[Date Time] ),
FILTER (
ALL ( 'Table' ),
'Table'[EscalationID] = EARLIER ( 'Table'[EscalationID] )
&& 'Table'[Date Time] > EARLIER ( 'Table'[Date Time] )
)
),
DAY
) + 1
try if #"Added Index"[EscalationID]{[Index] + 1} = [EscalationID] then Duration.Days( ( #"Added Index"[Date Time]{[Index] + 1}) - [Date Time]) + 1 else null otherwise null