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:



      how many calls were made to this client in total:



      how many orders came in:



      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?