Data Studio
1.6K members online now
1.6K 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.