How to get Max of a Dataset column in a SuiteAnalytics Dataset (not a saved search, and not in suitescript. This is for the dataset UI). And no, there is no MAX function listed in the Formula builder for Datasets.

AI generated answer (using internal Slack threads):

In SuiteAnalytics, there isn't a direct way to get the maximum of a column in a dataset through the UI. The MAX function is not available in the formula builder for datasets. However, you can achieve this by creating a workaround using a saved search. Here's a step-by-step guide: 1. Create a new saved search for the record type that contains the column you want to find the maximum value of. 2. In the Results subtab, add the column you're interested in. 3. Set the Summary Type of this column to Maximum. This will return the maximum value of the column across all records returned by the search criteria. 4. Save and run the search. Please note that this method will give you the maximum value across all records. If you want to find the maximum value for a specific subset of records, you need to add appropriate filters in the Criteria subtab of the saved search. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******