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

    Set Analysis - Greater then Date

      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.