Hi. I have a problem-solving ranking logic. On a dashboard page, I’m trying to view the ranking position for the current page user. There will be a few rankings, based on different filters (region, category).
I’ve got a list of Bookings for Activities. Each Activity is created by teachers. And also there are students who book an activity. What I am trying to do is to show the rank only for the current teacher, based on the number of Bookings in the Activity’s region or category.
I know how to get a sorted list of grouped bookings based on teachers:
Search for Bookings`` :filtered (by category or region) :group by teacher (count number of bookings) :sort by count. But I don’t have a clue how to get an index (rank) of a current teacher’s group and will it be possible with Bubble?
In the end, I will need to show it like:
Your ranking in the region: 5 (as an example)
Your ranking in category: 3
Thanks in advance for any help you can provide