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 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , the Best is to do Avg and then format, what you have done, unless you have some issue

Handle Time Average = FORMAT(AVERAGE('8x8'[Handle Time Minutes]),"HH:MM:SS")

 

in case the format does not work you can manually create

 

var _1 = AVERAGE('8x8'[Handle Time Minutes])

return

Quotient(mod([_1],86400),60) &":" & mod([Total duration ],60) &":00"