Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to calculate Average Queue Time

 How to calculate Average Queue Time    
DAX
Help required
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 
    Please refer to attached sample file with the solution

    Average 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
komald's avatar
komald
Icon for Helper I rankHelper I
3 years ago

Anonymous , Try this

create measure,
avg queue time=divide(sum(total queue time) , sum(calls queued))
put this measure in card

or

create calculated column
avg queue time= total queue time / queued calls

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,

Total queue time is in text format so unable to divide with call queued ..

  • komald's avatar
    komald
    Icon for Helper I rankHelper I
    3 years ago

    Anonymous , then use value function

    avg queue time= value( total queue time )/ value(queued calls)
    try this let me know is this work for u or not.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi,

       

      It's not working ..

      • komald's avatar
        komald
        Icon for Helper I rankHelper I
        3 years ago

        Anonymous , can you please share your dax with error?