First Time Ordering

[exg13563]

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!

[Ksrinivasan]

hi,

you can use

Load*,

if(AutoNumber(RowNo(),Customer)='1','1','0') as New_Cus_Count,

DIM: Date

Measure: Sum(New_Cus_Count)

ksrinivasan