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

Calculated fields: Top N

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Is there a way to create a calculated field that returns a dynamic Top N of whatever the selection is?

Re: Calculated fields: Top N

Follower ✭ ✭ ✭
# 2
Follower ✭ ✭ ✭
Short answer is... No. There is not a "Select Top N distinct" function.

But you a) can sort Descending in a Table and specify the number of rows instead.

Or b) use these calculated field...

MAX(X)
MIN(X)
AVG(X)
COUNT(X)

List of Functions: https://support.google.com/360suite/datastudio/table/6379764?hl=en

Thanks

Phil.