Show ranking of items in description

Ask for Help
1

Hi all,

I’m looking to present the ranking of an item in the description of a big number.

Here’s the scenario:

  1. Presenting data on hotels in various states.
  2. I have a big number sharing the number of rooms for each hotel.
  3. In the description of the big number, I want to display the ‘ranking’ in the state. So the hotel with 1,000 beds would have the description ‘#1 in state’.

Can someone help me with the calculation I need to plug into the data sheet, please?

2

How do you determine the ranking?
Is it purely based on the number of beds, or are there other factors?

3

Hey Darren, I’ll have several numbers I want to determine the ranking for. So I want to show its individual ranking in each category in different big numbers:

  • Most beds
  • Most reviews
  • Oldest

Etc

4

Try this:

1 Like
5

thanks I’ll take a look! Loved your video on comments