Forum Discussion
craigmon
Helper I
Helper IAverage call duration made per day
Hi Guys, Someone of this forum kindly wrote the below for me. This calculates the total time a person in making an external call. It works great but i an now trying to figure out how I can do ...
craigmon , Try like
Total outbound time new measure =
VAR Seconds = SUMX ( 'Calls SQL', SECOND ( 'Calls SQL'[Out Time] ) + MINUTE ( 'Calls SQL'[Out Time] )*60 + HOUR ( 'Calls SQL'[Out Time] ) *3600 )
var Seconds1 = divide(Seconds,[Count of Names])
RETURN
quotient(Seconds1,3600 ) & ":" & FORMAT ( quotient(mod(Seconds1,3600 ),60), "00" ) & ":" & FORMAT ( mod(mod(Seconds1,3600 ),60), "00" )
craigmonHelper I
Helper IThis is amazing thank you so much