NARY_MAX
is similar to MAX
, except that it lets you compare multiple values.
Sample usage
NARY_MAX(Event_1, Event_2
, Event_3)
Syntax
NARY_MAX( X
, Y
, [, Z
]*)
Parameters
-
X , Y , Z- fields or expressions to be evaluated.
Example 1
This example shows how you can mix fields, calculations, and literals in an NARY_MAX
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 that your data looks like this:
| Date | Region 1 Sales | Region 2 Sales | Region 3 Sales |
|---|---|---|---|
|
Date 1
|
100 | 200 | 150 |
|
Date 2
|
75 | 130 | 150 |
|
Date 3
|
225 | 185 | 230 |
You could use the NARY_MAX
function to determine the maximum sales for a given date:
Example formula
Date
Output
NARY_MAX(Region 1 Sales, Region 2 Sales, Region 3 Sales,)
Date 1
200
Date 2
150
Date 3
230
Notes
NARY_MAX
requires at least 2 arguments. At least one argument must be a field or an expression containing a field.
NARY_MAX
works on numeric fields or expressions only. If you apply this function to other data types, you'll get an error.
