Return index number of item in grouped list

Hi,

I’m trying to return the index of a given item from a grouped list, but can’t figure out how. Is there something I am overlooking?

I have a database of reviews of public speakers. I group these reviews by speaker, and calculate an average of the rating of their reviews. I would then like to be able to say something like, there are 56 public speakers. Ranked by average of rating, this current user is index #XYZ.

But I don’t know how :frowning: - any tips much appreciated

Best

Count the number with an average greater than this one.

2 Likes

That is … so much smarter than what I was doing. Thanks Nigel!