Rollup...by rank?

Is there anyway to get the sort order of a list based on value to the maximum? With rollup, I can get the max, avg and min, but I’d love to get the RANK of a list based on these values. Sure, I can sort by the value in an inline list, but i wanted to retrieve the ordinal number of each row in this sorted list. I could always use a spreadsheet formula, but was hoping to avoid it.

1 Like

Could you describe your use case, please?

Why do I think that this sentence will be in A LOT of @Robert_Petitto’s posts from now on?? :slight_smile:

2 Likes

For leaderboards, I’d like to generate the ranking of users instantly. This is important when it comes to the aesthetics of the tab as I’d use a series of filters to make those ranked 1-3 more pronounced (larger tiles) than those ranked 5-__. Here’s a mockup:

Ah, that’s an interesting use case!

1 Like

Thanks. I’d also like to apply the rank number to the labels of the components as well.

This is the closest I could get on this one. I have 20 items and I do get a rank from 1 to 20, but it includes decimals, so it’s still not quite right. I imagine there is some kind of math formula to figure this out, but I’m not that smart. However, writing code, I could figure this out in a matter of minutes.


Info on the formula:
http://mathforum.org/library/drmath/view/60433.html

1 Like

Wow. Closer than I got! I was just going to do a spreadsheet formula and call it a day! :clap:

1 Like

Hehe, yeah, that’s probably the best option for now.

Hey guys, I was able to figure out dynamic ranking, where as soon as a user’s x value changes, their rank among other users changes instantly as well.
All I did was use a rank formula (rank(x,y:y)) in my spreadsheet, then I used a relation, then a lookup, to pull in the rank. No formulas required.

Right. I was hoping to avoid formulas due to the lag.

1 Like

Ah. Gotcha. I haven’t noticed any significant lag so far. Maybe 3 seconds to update.

1 Like

I’d like to bump this feature request.

I think we need a Rank/Order functionality to sequentially number rows, either:

  • Along the entire contents of a sheet.
  • Or by specifying a grouping value, so each group has its own unique numbering.

Then within that sheet or grouping, I’d like to specify a column to rank by, either:

  • Numerically
  • Alphabetically
  • Date Order
  • Etc.

Then finally the ability to choose to number in:

  • Ascending order
  • Descending order

I was thinking of ways to build this into an existing column type, such as rollup, math, or single value, but maybe it would be better as its own column type. What I’m thinking is a Rank column with 3 setting options.

  • The first setting option is to select the entire sheet, or select a specific column to group by.
  • The second setting option is the actual value you want to rank by (such as a score or a date), or you can choose to select nothing and it will number by sheet order.
  • The third option would be Ascending/Descending order so it numbers from top-down or bottom-up if nothing selected for option 2, or it numbers from lowest-greatest or greatest-lowest if you selected a value to rank by in option 2.

I’ve beat my head against the wall trying to find a way to mathematically rank the data in a row using only glide functionality, and so the results are sequential whole numbers. I feel like there is some magic math formula that could do this but I’ve been unable to figure it out or find a solution the didn’t suggest programmatically sorting and looping the data, or simply using a Rank function (which we don’t have…yet).

2 Likes

Thanks @Jeff_Hager!

Yes, you’re absolutely right! I’ve tried researching ways to mathematically rank a list of items and 99% of the posts out there are reference using the =rank() formula :roll_eyes:

Your thoughtfulness regarding the layout of the Rank Column is spot on :100:

3 Likes

I can’t even vote for my own post :confused:
Screen Shot 2021-02-10 at 9.26.02 AM

1 Like

Yeah, I was getting into math formulas that were well above my skill level and I had no idea if they were even what I was looking for. Seems simple, but apparently not.

Oh… so what, like Quantum Math? :joy:

1 Like

Ha! Not quite. Finite Math (a little above algebra and a little below calculus) was as far as I got in college. Most of that knowledge is long gone. Anything above basic algebra is above my league. If there are symbols in the formula that aren’t letters or numbers, then I’m out. About the only symbol I know and understand is ∑ but I only know how to apply it programmatically.

1 Like