Is there a way to rank values in quickbase similar to Excel's RANK function?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

I need help ranking values from largest to smallest in Quickbase. In the past, I have used Excel's RANK function to achieve this, however I am coming up empty trying to mimic this function in Quickbase. A simple sort on the field will not work. I am analyzing data broken down by State and Regions, so I have multiple fields that I want to be able to see the ranking for, so that I can compare those rankings side by side without having to sort by each column. Thanks in advance for any help.

Photo of Michael

Michael

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
You have to use script to do this. Feel free to contact me off-world using the information in my profile if you need personalized assistance to implement this.
Photo of RateSpy

RateSpy

  • 60 Points
Hi Dan, I wasn't able to find your email. Would you be able to email me at info@ratespy.com? I have a similar need (to rank records) and need to hire someone to help. Thanks!
Photo of Michael

Michael

  • 0 Points
Thanks Dan! I just sent you an email.