Data Studio
4.8K members online now
4.8K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

nary_max - what is it?

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

What is this function?  Where can I find an example if use ( not just docs on parameters )?

 

Thanks!

1 Expert replyverified_user

nary_max - what is it?

Google Employee
# 2
Google Employee

Hi Paul,

 

n-ary operators work on a variable number (n) of inputs, as opposed to binary operators, which just work on 2 inputs, or unary operators, which only work on one input. (I'm not a mathematician so I'm sure I'm oversimplifying). 

 

Here's an example from the autocomplete help for the function:

 

Examples
NARY_MIN(10, SUM(cost), revenue)
NARY_MIN(SUM(cost), revenue, clicks, sessions))
 
By comparison, the MIN function would only let you return the minimum value in a single dimension.
 
Hope this helps!
 
Rick