Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all! I have a list of orders dating back to 1/1/2016 and want to find out if a customer is ordering for the first time or not when it comes to a specific product.
I have a calendar date range filter and want to be able to select a date range and see how many customers are ordering for their first time ever.
If my fields are: Order Date, Order #, Account #, Product how would I type out the expression so that when i click a date range it will provide me the # of customers ordering for the first time? (example: If Product A, then first time customer ordering that product in a given time frame)
Thanks in advance!
hi,
you can use
Load*,
if(AutoNumber(RowNo(),Customer)='1','1','0') as New_Cus_Count,
DIM: Date
Measure: Sum(New_Cus_Count)
ksrinivasan