4 Replies Latest reply on Feb 26, 2013 8:25 AM by Vincent Atwood

    Count number of calls between first call and first order

    Vincent Atwood

      I have adata Extract with customer call history (CALL_DATE, CALL_REC_NUM, calls_BSNSS_ID, ..) and purchase history (BILL_DT, ORDER_NUM, orders_BSNSS_ID, BOOKED_AMT,...).  I am able to calculate:

       

      how many days there were before the first order was placed using:

      DATEDIFF('day',[MIN CALL_DATE],[MIN BILL_DT])

       

      how many calls were made to this client in total:

      COUNTD([CALL_REC_NUM])

       

      how many orders came in:

      (COUNTD([ORDER_NUM]))

       

      But I do not know how to calculate how many CALLS [CALL_REC_NUM] were placed before the first order [BILL_DT] came in??  Can anybody help?