Forum Discussion

craigmon's avatar
craigmon
Icon for Helper I rankHelper 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's avatar
    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
craigmon's avatar
craigmon
Icon for Helper I rankHelper 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's avatar
negi007
Icon for Community Champion rankCommunity 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