Most Recent Sale in SuiteAnalytics DataSets
I’ve dug out all my ideas on this one but can’t seem to do it in SuiteAnalytics. All the tools that we would have used with Saved Searches (Summary Types, Summary Criteria plus functions like MAX and DENSE_RANK) aren’t available in the SuiteAnalytics world.
I guess, for the minute, they’re relying somewhat on the use of Pivot Tables, etc. And, in that respect, you can sort of get to what you want. It’s possible to create a pivot that lists Customers alongside their last Sales Order date. Let me know if that would be remotely useful and I can happily provide some steps, if needed.
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.