10 Replies Latest reply: Jul 3, 2014 2:34 AM by Eugen Heier RSS

    Set Analysis - Greater then Date

    Eugen Heier

      Hi all,

       

      I have the following problem. I must determine the number of (following) orders from customers who have purchased a particular (selected) product in the first order.

       

      At the moment I have a feeling that my Set Analysis formula ignored the part with order_date.

       

      Count({1<customer_id=P({<first_order={'Y'},product_id=P(product_id)>} customer_id),order_date={">$(=Date({1<first_order={'Y'},product_id=P(product_id)>} order_date))"}>} DISTINCT order_id)
      

       

      Can you please look at you the formula.

       

      Thanks