op.max

op.max(
   aggColName as String,
   columndef as String,
   [options as String]
) as aggregatedef

Summary

This function gets the largest non-null value of the column for the rows in the group or row set. The result is used for building the parameters used by the prototype.groupBy function.

Example

const op = require('/MarkLogic/optic');

op.fromView('main', 'expenses')
   .groupBy('Category', op.max("Maximum Spent", "Amount"))
   .orderBy('Category')
   .result();