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

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 )?



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:


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!