Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Average Handling Time without 0's

I need an average handling time. So I have done a new column with the total-time column divide 86400 and put the format as time.           Handle Time Minutes = DIVIDE('8x8'[total-time...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Please try this formula.

    Handle Time Average =
FORMAT (
    AVERAGEX (
        FILTER ( ALLSELECTED ( '8x8' ), [Handle Time Minutes] <> 0 ),
        '8x8'[Handle Time Minutes]
    ),
    "HH:MM:SS"
)

     

    Best Regards,

    Jay 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Anonymous , try this measure:

Handle Time Average (Excl zero) =
   FORMAT(
      CALCULATE(
         AVERAGE('8x8'[Handle Time Minutes]),
         '8x8'[Handle Time Minutes] <> 0 
       ),
       "HH:MM:SS"
    )