I’m currently using a formula to sum a number grouped by people—which works great!

The formula I can’t seem to figure out now in the table filter is to show unique rows based on a people column.

Context: I track the number of email replies our team sends in a table, per day. I’m filtering based on the last 7 days, and I would like to know the sum of replies sent in those 7 days, and only see one row per team member.

Right now, the sum is working, but I see the same team member multiple times (as many rows there are for the days replies were sent):

Hi @Troy_Larson —thanks for the assist, and sharing the demo!

This is indeed what I created earlier, but the problem is that I can’t sort on the sum. So, basically what I did is use a formula to create a sum, aggregating per “people”. This does work really well, however, I just need the unique rows based on the people, otherwise I can see the top-scorers in the table multiple times.

Hi @Troy_Larson , thanks so much for the continued effort!

This is indeed also another solution I had tried, and while it does work for the sum and grouping, I can’t sort on the SUM itself in descending. I can only do that, I believe, if there is a separate column in the table with a sum per person and therefore I’m getting the near duplicate records.

The idea is to create a weekly leaderboard and show the top senders at the top of the table.

I wonder if, perhaps, this is just not possible right now?

Hi @Troy_Larson , thank you so much! This is indeed EXACTLY what I was looking for (the Display in Leaderboard field formula)—thank you so much!

Although I wouldn’t need it now, I’d like to add on a dimension if possible?

So, we have different people spending different time on email. E.g. person A could do 10h in a given week, and person B could do 20h.

What I would love to calculate is the replies per hour, calculated on the week:

E.g. (sum of weekly replies) / (sum of weekly hours)

Important here is that we shouldn’t do the average of an average, rather calculate RPH based on the whole week, so each day isn’t weighted equally per day, but rather calculated on weekly sums.

Then do a similar approach to rank highest RPH on top and have one record/row per person, per team, per week.