New customer grouping

[aytacbas]

Hi All;

I've a table  and it has 3 values customer_id, Order_id and Order_date ;

I want to find  new customers rate daily

How can I do that?

[ramoncova06]

you can use peek for this

load

if(customer_id = peek('customer_id'), 0, 1) as NewCustomerFlag,

customer_id,

Order_id,

Order_date

order by customer_id,Order_date;

load

customer_id,

Order_id,

Order_date

from your source;

[buzzy996]

u can use Ramon script and use that flag in ur chart object with NewCustomerFlag='0' and do the rest of calculations.