NARY_MAX

The NARY_MAX function returns the maximum value of the input arguments.

NARY_MAX is similar to MAX, except it allows you to compare multiple values.

In this article:

Syntax

NARY_MAX(X, Y, [,Z]*)

Output type

By default, NARY_MAX returns an unaggregated dimension.

Examples

Example 1

This example shows how you can mix fields, calculations, and literals in an NARY function:

NARY_MAX(REVENUE, (COST * 2), 10, SESSIONS))

Example 2

Suppose you want to determine the maximum sales for your 3 sales regions by date and your data looks like this:

Date Region 1 Sales Region 2 Sales Region 3 Sales
Apr 17, 2018 100 200 150
Apr 18, 2018 75 130 150
Apr 19, 2018 225 185 230

You could use the NARY_MAX function to determine the maximum sales for a given date:

NARY_MAX(Region 1 Sales, Region 2 Sales,Region 3 Sales,)

Date NARY_MAX calculated field
Apr 17, 2018 200
Apr 18, 2018 150
Apr 19, 2018 230

Notes

NARY_MAX requires at least 2 arguments.

At least one argument must be a field or an expression containing a field.

All arguments must be of the same semantic type, i.e., all numbers. For example you can't perform an NARY function on a number, a text field, and a date.

Related resources

Was this helpful?
How can we improve it?