6 Replies Latest reply: Sep 11, 2014 6:03 AM by Ramya Uniyal RSS

    Getting value for a dynamic date range using Set Analysis

    Ramya Uniyal

      Hi,

       

      I am new to Set Analysis, appreciate your inputs on the following scenario. I have a table as follows:

      Service Number
      Service DateCustomer ID
      100019/1/20141
      100029/2/20141
      100039/12/20141
      100049/2/20142
      100059/5/20142
      100069/3/20143
      100079/12/20143
      100089/4/20144
      100099/5/20144
      100109/6/20145
      100119/21/20145

      Problem: I need to find the distinct number of customers who availed a service for the first time for a date range (say in this case from 9/1/2014 to 9/5/2014) and then came back within 5 days of availing the service. In the above example the count should consider only the customers 1, 2 and 4.

       

      Thank you!