Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
is it possible to write an Set Analysis Expression like this:
I want to count all orders from date in Column min_order_date for every customer.
Any idea?
Thanks.
hi have a look at the attach example
What is Order_Date and What is Min_Order_Date ?
If possible, please provide some few lines sample data.
min_order_date=Min({1<order_id=P({1<product_id={'$(=Only(product_id))'}>} order_id)>} order_date)
:: It is a first Order-Date from Customer who buy a specific product.
My SRC looks like this:
customer_id,order_id,order_date,product_id
Would like to try this if you can provide some sample data...
hi
set expression won't work
because in set analysis you'll find the min date of all customers and products
set analysis returns the same value to all the rows in the chart
why not use the column you created in the chart in the next expression
If will be the best way to do this.
If possible please send a sample.
sample file
Thank You
sample file is uploaded
That's what I already suspected
Set Analysis will not work but need to find some trick ...!