Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Division by categories

  Hello guys, I would like to do the following division:  Avg Call length equal to ("Engage Time" plus "Wrap Time") divide "Accepted" Yet my calculated result seems wrong as the table below
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous ,

     

     

     

     

    Call Length = DIVIDE([Total Engage Time] + [Total Wrap Time] , SUM(Table9[Accepted]))
     
    Total Engage Time = SUM(Table9[Engage Time])
     
    Total Wrap Time = SUM(Table9[Wrap Time])
     
     
    Regards,
    HN
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for your quick reply. 

 

I tired it before, yet still, fail to show the correct answer:(

 
 



amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous ,Can you share sample data and sample output. Mark me @

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak 

    Sample Data:

    Agent NameQueueAcceptedEngage TimeWrap Time
    aUNKNOWN19850
    aVQ_Supervisor_Hotline16610
    aUNKNOWN22735
    aVQ_Supervisor_Hotline12236
    aUNKNOWN428220
    aVQ_ElderlyAndDisable14213
    aVQ_Supervisor_Hotline1146
    aUNKNOWN884270
    aUNKNOWN102599196
    aUNKNOWN858230
    aUNKNOWN623238
    aVQ_Supervisor_Hotline17888
    aUNKNOWN85178958
    aVQ_ElderlyAndDisable352365
    aVQ_Supervisor_Hotline114813
    aUNKNOWN53061143
    aUNKNOWN618760
    aVQ_Supervisor_Hotline1125
    aUNKNOWN831051
    aVQ_ElderlyAndDisable1283426
    aVQ_Lang_English133875
    aUNKNOWN621478
    aVQ_Supervisor_Hotline1141378
    aUNKNOWN43602147
    aVQ_ElderlyAndDisable133082
    aUNKNOWN112430
    aUNKNOWN72130143
    aUNKNOWN19810
    aVQ_Supervisor_Hotline1345438
    aUNKNOWN53224428
    aVQ_Lang_English1556274
    aUNKNOWN25410
    aUNKNOWN311480
    aUNKNOWN2109816
    aVQ_Supervisor_Hotline1154
    aUNKNOWN6195115

    Sample Output 

    Agent QueueTotal AcceptedTotal EngageTotal WrapAvg Call Length
    aUNKNOWN103545372068549.5631
    aVQ_Supervisor_Hotline9841978202.1111
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous ,

       

       

       

       

      Call Length = DIVIDE([Total Engage Time] + [Total Wrap Time] , SUM(Table9[Accepted]))
       
      Total Engage Time = SUM(Table9[Engage Time])
       
      Total Wrap Time = SUM(Table9[Wrap Time])
       
       
      Regards,
      HN
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Anonymous 

         

        Thanks for your advice. I did so following your instructions yet I found a wired thing that makes an inaccurate result.

         

         

        The data in the data field following your advice:

         

        The data in the report view and the number was much larger than the data in data view: