Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Saved Search for Average Days Between the Purchase of an Item
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