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

Max Function - How do you identify the top 3 values in a list of values

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I need to identify from 10 values the Max, 2nd Max and 3rd Max value....is that possible and how?

Max Function - How do you identify the top 3 values in a list of values

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

in your chart, order them by "value descending" 

Re: Max Function - How do you identify the top 3 values in a list of values

[ Edited ]
Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I want to create a calculation that adds the value of the top 3 values and
not just see them in a list....can it be done?
In Excel you would probably just do a LARGE function formula

--

Max Function - How do you identify the top 3 values in a list of values

Follower ✭ ☆ ☆
# 4
Follower ✭ ☆ ☆

I double this question: I need to display top 20 rows out of 30k in a 2 pages table (2 pages by 10 rows). Data is pages and pageviews pulled from Analytics.

Filtering the data is not working here because top 20 values are variable. 

 

Any workaround is highly appreciated.

Thank you.