RE: Most Recent Sale in SuiteAnalytics DataSets
Answered
Is there a way to return the most recent sale for a customer in SuiteAnalytics DataSets? Or even for the most days since created. I know it can be done in a search but I need to do it in a Workbook
Thnx Chris, I was hoping that that would not be the answer. The query is a bit more complicated that last sales order, the customer wants the last SO date, days since the last phone call, Days since last visit and a few more fields that only the grouping functionality of a SS can achieve but as they are all on different records I need to use SA to get all the data. I will just stick with my original idea of updating the customer record for now and run a SS from there.
Thnx
