Ok I want to find the number of days between a cancellation and purchase without including repeat cancellations...
So if new customer then initial value for purchase history = A
If they looked at data put it in cart and no purchase = B
Purchase = C
So I want to get the following data from a pattern
new customer A
So I would like to know the results of days between every instance of B if it follows a C or A. Without getting results for any B which follows a B.
IE the January 7 B had a C appointment three days later.
I would get no results from the Jan 8 or 9th B.