AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

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

Pull a rank into a scorecard

Participant ✭ ✭ ☆
# 1
Participant ✭ ✭ ☆

I have a Google spreadsheet that loads into DS with the total number of FB followers for my company and a number of our competitors. I've created a table with row numbers to get at a rank. However, I'd also like to pull just my company's rank into a scorecard. Is there any was to do this through a calculated metric to create the rank, without having to make it via formula in GS? The complicating factor is that we have both local and national competitors, and I want a separate rank for overall, local, and national.