In SuiteAnalytics DataSets, it is not currently possible to directly return the most recent sale for a customer or find records based on the most days since creation, as features like Summary Types, Summary Criteria, and functions like MAX and DENSE_RANK (available in Saved Searches) are not supported.
As a workaround, you can use Pivot Tables in SuiteAnalytics Workbooks to display customers alongside their last Sales Order date. This approach may provide a partial solution, but it lacks the precision and flexibility of Saved Searches. If further steps are needed, guidance on setting up such a pivot can be provided.