Returns the maximum value in a column.
Find the maximum number sold.
Find the maximum number sold, categorized by city.
max(double expr, [groupBy(...)]))
- expr : expression returning
groupBy: optional grouping function
doubleor as many
doubles as there are groups if
You must include all the leading grouping dimensions in the Insight from the top-down to the level-based measure you want to evaluate. See Aggregation with Level Based Measure in Aggregating Functions.