Forum Discussion
Anonymous
3 years agoNot applicable
How to calculate Average Queue Time
How to calculate Average Queue Time
- 3 years ago
Hi Anonymous
Please refer to attached sample file with the solutionAverage Queue Time = VAR TotalTime = [Queue Time] VAR TotalSeconds = SECOND ( TotalTime ) + MINUTE ( TotalTime ) * 60 + HOUR ( TotalTime ) * 3600 VAR AverageSeconds = DIVIDE ( TotalSeconds, SUM ( 'Table'[Calls Queued] ), 0 ) VAR Hours = FORMAT ( QUOTIENT ( AverageSeconds, 3600 ), "00" ) VAR BalanceSeconds = MOD ( AverageSeconds, 3600 ) VAR Minutes = FORMAT ( QUOTIENT ( BalanceSeconds, 60 ), "00" ) VAR Seconds = FORMAT ( MOD ( BalanceSeconds, 60 ), "00" ) VAR Result = Hours & ":" & Minutes & ":" & Seconds RETURN Result
Anonymous
3 years agoNot applicable
amitchandak, can you help me out for same