fbpx
Select Page

Find the maximum value for a column or group.

Usage

Max(<field>)

field (required) The column to be searched. The function will search Numbers, Dates, and Strings, returning the maximum value.

NOTE: Sort order is affected by your database settings. For strings, sort order is most often blank spaces > special characters > numbers > uppercase letters > lowercase letters

For numbers, preceding and trailing zeroes most often have no effect on sort order.

Examples

Max([Invoice Date])
  • Finds the greatest Invoice Date, which is the most recent invoice date.
Max([Name])
  • Finds the name that is the last alphabetically.

See Also

CumulativeMax
Min
MovingMax
Greatest

More About Aggregate Functions

Aggregate functions are special functions which summarize columns from lower levels. Aggregate functions can be used on on Grouped levels or in a Total column. For example, they can be used to Sum all of the values of a column, or Count all of the values for each grouping of a column. As such, aggregates must always refer to columns in a level lower than the result.

If the column being aggregated is grouped, then the aggregate is computed for each group. For example, if the worksheet is grouped by the column [Year], then placing Sum([Revenue]) on the [Year] level computes the revenue for each year.

The results of aggregate functions can be referenced by lower levels. An example would be to create a Sum([Amount]) column as Total and then an [Amount] / [Total] column as Percentage. This converts each Amount value into a relative percentage value.

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.