my data looks like shown in the file attached. I have in each line an order from a customer. One customer can have multiple orders and the customer is identified by his/her e-mail address (i don't know if that is so smart but for now it is like this
). Now i need to rearrange the data in the way that i have in each line the customer with his/her order details including the different dates of order. My goal is to calculate the average inter-purchase time and the difference from today to the last order date. I hope it's understandable now.
Thanks for your help!
You do not have the required permissions to view the files attached to this post.