Forum Discussion

Helper I

5 years ago

Solved

Call Centre Duration in a line graph

Guys, Is it still the case that we are unable to put time duration into a line graph. Its defo not letting me do it at the moment. The below shows the average outbound call time each contact centre...

Need Help

negi007
5 years ago
craigmon in this case i suggest you to first create a calculate column to convert timevalues into seconds so that all values are in seconds. Then you create a measure to arrive a minute calculation. This should be able to help you.

Calculated column:

time(seconds) = (HOUR('Table'[Time])*60*60 + MINUTE('Table'[Time])*60)

Measure:

time(minutes) = SUM('Table'[time(seconds)])/60

now you can use the measure in our chart. let me know if it helps you. thanks

negi007

Community Champion

5 years ago

craigmon you can convert your time values into minutes and then show minutes in the chart like below

time(minutes) = HOUR('Table'[Time])*60 + MINUTE('Table'[Time])

let me know if it works for you.

craigmon

Helper I

5 years ago

Thanks for that. It does work on some of my columns but not on the below measures. Is there any way around this? Many thanks

Total outbound time average =

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" )

Total inbound time new measure = VAR Seconds1 = SUMX ( 'Calls SQL', SECOND ( 'Calls SQL'[Total Inbound Time] ) ) VAR Minutes1 = SUMX ( 'Calls SQL', MINUTE ( 'Calls SQL'[Total Inbound Time] ) ) VAR Hours1 = SUMX ( 'Calls SQL', HOUR ( 'Calls SQL'[Total Inbound Time] ) ) VAR Seconds2 = MOD ( Seconds1, 60 ) VAR Minutes2 = MOD ( TRUNC ( Seconds1 / 60 ) + Minutes1, 60 ) VAR Hours2 = Hours1 + TRUNC ( ( TRUNC ( Seconds1 / 60 ) + Minutes1 ) / 60 ) RETURN Hours2 & ":" & FORMAT ( Minutes2, "00" ) & ":" & FORMAT ( Seconds2, "00" )

negi007
Community Champion
5 years ago
craigmon in this case i suggest you to first create a calculate column to convert timevalues into seconds so that all values are in seconds. Then you create a measure to arrive a minute calculation. This should be able to help you.

Calculated column:

time(seconds) = (HOUR('Table'[Time])*60*60 + MINUTE('Table'[Time])*60)

Measure:

time(minutes) = SUM('Table'[time(seconds)])/60

now you can use the measure in our chart. let me know if it helps you. thanks