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.

# Rollup...by rank?

Could you describe your use case, please?

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!

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

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

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