RE: Most Recent Sale in SuiteAnalytics DataSets

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

Rhys Gottwald Beginner Asked on September 2, 2020 in Workbooks.
Add Comment
2 Answers

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.



Beginner Answered on September 3, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.