Hi,
I am not sure what I am asking for is possible with a saved search, but wanted to see if anyone knew how to do it.
We need a search that shows the items a customer orders as well as the average number of days between the purchase of said items. For instance our customers order the same items on a pretty regular basis. If the customer is ordering the item say every month we would like to be able to see this in a search. The search should look something like this.
Customer | Item | Average Days Between Purchase | Days since last Purchase
Bob Smith | ItemX | 31.55 | 33
Bob Smith | ItemY | 62.75 | 57
Bob Smith | ItemZ | 85.45 | 22
etc.
Can you get this data point out of a saved search?
Thank you.