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