How to get Max of a Dataset column in a SuiteAnalytics Dataset (not a saved search)

AI generated answer (using internal Slack threads):

To get the maximum of a column in a SuiteAnalytics Dataset, you can use the

Column.aggregate

function in combination with

Column.groupBy

. The

Column.aggregate

function allows you to perform aggregate operations such as SUM, COUNT, AVG, MIN, MAX, etc., on a column in a dataset. Here is a sample code snippet:

javascript
var myColumn = myDataset.columns[0];
myColumn.aggregate = 'MAX';

In this example,

myDataset.columns[0]

is the column you want to get the maximum value from. The

aggregate

property is set to 'MAX' to get the maximum value. Remember to group your data appropriately using

Column.groupBy

to ensure you're getting the maximum value within the correct context. For example, if you're looking for the maximum quantity sold per item, you would want to group by the item. Please note that this is a JavaScript example using SuiteScript, which is the scripting language used in NetSuite. If you're not familiar with SuiteScript, you may want to look into the NetSuite Help Center or SuiteAnswers for more information. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******