Skip to main content
Question

How to rank by count?

  • February 24, 2026
  • 1 reply
  • 21 views
R
Forum|alt.badge.img+1

I’m making an analytics dashboard for a client. They want to be able to see the top X records by viewcount, which we track. When I make a graph for this, there’s simply too many records and the bar chart looks a mess.

I want to create a formula field that has a rank and I can include the top 5 records in a bar chart. What’s the right approach for this? I am not a developer and hoping to avoid an automation w script.

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31

Doable, but we’d need to create a new table for this and here’s what it’d look like ranking the top 2.  The bar chart would then be filtered by these two fields to only show the top two records, does that make sense?

I’ve set it up here for you to check out!

Steps:

  1. Create a new table called ‘Rank Helper' or something and create one record in it called ‘Helper’
  2. Link every data record to the ‘Helper’ record
    1. We’d use an automation to do this link for us on a day to day basis
  3. In ‘Rank Helper’, create a rollup field with ‘MAX(values)’ to display the highest value of all the linked records:

    1.  

  4. In the data table, create a rollup field with ‘SUM(values) = Sales’ to get it to identify the record with the highest value:
  5. In ‘Rank Helper’, create another rollup field, except this time conditionally filter out the highest value from the previous step:
    1.  

       

  6. In the data table, create a rollup field the same way we did for step 4.1:

And we’d just repeat this process for ranks 3-5

Adam, Airtable Consultant - thetimesaving.company
Terms & ConditionsAccessibility statement