Looker Studio is now called Data Studio. Learn more about this change.
NARY_MAX
Stay organized with collections
Save and categorize content based on your preferences.
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.