Forum Discussion
How to calculate Average Queue Time
How to calculate Average Queue Time
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
VALUE(SUM('Raw Data'[Total Queue Time])) / SUM('Raw Data'[Calls Queued]))
komald
Helper I
Helper IAnonymous ,
let me check
- komald
Anonymous , if i ans your question please mark as a solution. Thanks
Hi,
Still it's not done , i am sharing some more raw data for more clarity.. can you please check ..
left side is raw data and right side table is output .. i wanted to show same output table..
can you please help me out..
thanks in advanced..
Raw data
Date Interval Calls Queued Total Queue Time 02-05-2022 02:00-02:30 0 00:00:00 02-05-2022 02:00-02:30 0 00:00:00 02-05-2022 02:00-02:30 0 00:00:00 02-05-2022 02:30-02:60 2 00:01:43 02-05-2022 02:30-02:60 0 00:00:00 02-05-2022 02:30-02:60 1 00:00:43 02-05-2022 02:30-02:60 1 00:02:42 02-05-2022 02:30-02:60 1 00:07:43 02-05-2022 02:30-02:60 0 00:00:00 02-05-2022 02:30-02:60 2 00:02:10 02-05-2022 02:30-02:60 2 00:02:29 02-05-2022 02:30-02:60 0 00:00:00 02-05-2022 05:00-05:30 1 00:05:24 02-05-2022 05:00-05:30 0 00:00:00 02-05-2022 05:00-05:30 2 00:05:55 02-05-2022 05:00-05:30 1 00:00:43 02-05-2022 05:00-05:30 0 00:00:00 02-05-2022 05:00-05:30 1 00:01:36 02-05-2022 05:00-05:30 1 00:00:09 02-05-2022 05:00-05:30 1 00:00:22 02-05-2022 05:30-05:60 1 00:18:25 02-05-2022 05:30-05:60 2 00:09:18 02-05-2022 05:30-05:60 0 00:00:00 02-05-2022 05:30-05:60 1 00:02:53 02-05-2022 05:30-05:60 2 00:07:56 02-05-2022 05:30-05:60 1 00:04:22 02-05-2022 05:30-05:60 1 00:01:01 02-05-2022 05:30-05:60 1 00:02:52 02-05-2022 05:30-05:60 1 00:07:21 Result Interval Calls Queued Total Queue Time Average Queue Time(Total queued / call queued) Total 26 1:25:47 0:03:18 02:00-02:30 0 0:00:00 0:00:00 02:30-02:60 9 0:17:30 0:01:57 05:00-05:30 7 0:14:09 0:02:01 05:30-05:60 10 0:54:08 0:05:25 tamerj1 ,can you please solve this..