Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is there any way to depict " order_date> P () " in Set Analysi?