Forum Discussion

Giant_Pygmy's avatar
Giant_Pygmy
New Member
7 years ago

Figuring counts based on time frame.

So I figured this would be simple but the answer has alluded me.   I have a table that holds call informaiton.   One column is for the Telephone Number of the caller, one is the Queue the caller called into, and one is the Date the call took place.   What I'm needing to do is find a way to count how many times a customer called back in within a three week period.  So essentially if a customer had 2 or more calls happen within a three week period count it, otherwise exclude it.  I haven't figured out how to accurately count only calls that have happend twice or more.  I finally figured out how to count calls between dates but not sure if this is the correct path since this will count all calls instead of just the multiple onces.  (BeginDate and EndDate are just datediff 3 weeks from all date in either direction)

 

TestingMeasure:=CALCULATE(COUNTROWS(F_QUEUE_CALL_DETAIL),FILTER(F_QUEUE_CALL_DETAIL, ([BeginDate] <= LASTDATE(D_DATE[Date])
&& [EndDate]>= FIRSTDATE(D_DATE[Date]))))

3 Replies

  • v-xicai's avatar
    v-xicai
    Community Support

    Hi Giant_Pygmy ,

     

    I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

     

    Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

     

    Best Regards,

    Amy

     

  • The goal is to identify if a tel# has called back in within a certain timeframe (3 weeks) and if it has then to count it.  Ultimately this will be used to figure out a resolution effectiveness KPI.  The theory is if a customer had to call back in then the issue was not resolved.

     

    Sample Data

    CallDatePhonePhoneQueue
    1/1/2019789-555-0184CustService
    1/1/2019344-555-0181Billing
    1/1/2019264-555-0164TechSupport
    1/1/2019727-555-0190Billing
    1/1/2019273-555-0181TechSupport
    1/1/2019429-555-0145CustService
    1/1/2019334-555-0146CustService
    1/1/2019927-555-0198CustService
    1/1/2019221-555-0141CustService
    1/1/2019539-555-0142CustService
    1/2/2019206-555-0195Billing
    1/2/2019250-555-0127Billing
    1/2/2019661-555-0168CustService
    1/2/2019426-555-0181CustService
    1/2/2019159-555-0190Billing
    1/2/2019292-555-0128TechSupport
    1/2/2019987-555-0126CustService
    1/3/2019397-555-0144Billing
    1/3/2019119-555-0144Billing
    1/3/2019652-555-0115CustService
    1/3/2019383-555-0111CustService
    1/3/2019752-555-0187TechSupport
    1/3/2019428-555-0176TechSupport
    1/3/2019884-555-0193CustService
    1/3/2019773-555-0182CustService
    1/3/2019542-555-0164Billing
    1/3/2019941-555-0155Billing
    1/3/2019140-555-0143CustService
    1/3/2019945-555-0112Billing
    1/3/2019539-555-0182Billing
    1/4/2019889-555-0176CustService
    1/4/2019859-555-0173CustService
    1/4/2019119-555-0167Billing
    1/4/2019115-555-0113Billing
    1/4/2019937-555-0136CustService
    1/4/2019680-555-0192CustService
    1/4/2019219-555-0126Billing
    1/4/2019839-555-0198TechSupport
    1/4/2019551-555-0155CustService
    1/4/2019188-555-0152Billing
    1/4/2019767-555-0151CustService
    1/4/2019394-555-0176Billing
    1/4/2019820-555-0166Billing
    1/4/2019358-555-0188CustService
    1/4/2019819-555-0186CustService
    1/5/2019175-555-0198TechSupport
    1/5/2019752-555-0185TechSupport
    1/5/2019572-555-0156CustService
    1/5/2019138-555-0156CustService
    1/5/2019143-555-0113Billing
    1/5/2019147-555-0192Billing
    1/5/2019835-555-0116CustService
    1/5/2019722-555-0169Billing
    1/5/2019576-555-0171Billing
    1/5/2019156-555-0187CustService
    1/5/2019706-555-0140CustService
    1/5/2019754-555-0134Billing
    1/5/2019899-555-0134Billing
    1/5/2019169-555-0178CustService
    1/5/2019698-555-0183CustService
    1/5/2019429-555-0145CustService
    1/5/2019916-555-0137Billing
    1/5/2019158-555-0188TechSupport
    1/5/2019362-555-0121CustService
    1/6/2019539-555-0121Billing
    1/6/2019962-555-0144CustService
    1/6/2019716-555-0123Billing
    1/6/2019674-555-0188Billing
    1/6/2019186-555-0135CustService
    1/6/2019847-555-0151CustService
    1/6/2019425-555-0158TechSupport
    1/6/2019185-555-0190TechSupport
    1/6/2019691-555-0149CustService
    1/6/2019834-555-0132CustService
    1/6/2019962-555-0112Billing
    1/6/2019753-555-0179Billing
    1/6/2019554-555-0124CustService
    1/6/2019156-555-0187CustService
    1/6/2019252-555-0127Billing
    1/6/2019581-555-0172Billing
    1/6/2019153-555-0114CustService
    1/6/2019957-555-0125CustService
    1/6/2019941-555-0155Billing
    1/6/2019329-555-0183Billing
    1/6/2019475-555-0188Billing
    • Giant_Pygmy's avatar
      Giant_Pygmy
      New Member

      A couple sample ideas on how to flag those telephone numbers:

       

      Month/QueTelNumberDupFlag
      Jan  
      CustService  
       429-555-01451
       156-555-01871
      Billing  
       941-555-01551

       

      QueueJan
      CustService94%
      Billing98%
      TechSupport92%