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
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , Something like this should work

 

divide( [Engage Time] + [Wrap Time], [Accepted])

or
divide( table[Engage Time] + table[Wrap Time], table[Accepted])

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

    Hi Anonymous ,

     

    DIVIDE (
    CALCULATE (
        SUMX (
           'Agent Reort 09',
            'Agent Reort 09'[Engage Time] + 'Agent Reort 09'[Wrap Time]
        )
    ),
    'Agent Reort 09'[Accepted]
)

     

    Pl do let me know if this works.

     

    Regards,

    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous 

      It doesn't come up with correct answer as well:(