Repeat Customer Or Not

[risabhroy_03]

I have a set of data where I want to add a new flag whether that customer is a repeat Customer or not.

Condition - If a customer buys multiple products on the same date then he is not a Repeat Customer.

If a customer buys products on different days, then it is a Repeat Customer.

Below is a repeat customer - 

below is the non repeat customer

Plz help.

[justISO]

Hi, in front end you can try something like this:

if(aggr(count(distinct LinkCommnonDate), RepurchaseMember)>1, 'Repeat', 'Non-Repeat')