How to Filter a Leaderboard so Only Unique Team Names Display

I have a leaderboard that is displaying the total “points” for a team. There are two people on each team. I’m having trouble figuring out how to set it up correctly to only display each team once.

It’s currently an inline list of the users table. I’m filtering to only display teams who have a point total > 0, but I can’t think of something to filter out duplicates. I tried playing around with creating a Unique Array of team names without success. I’m using a unique array to display which users are on which team based on a lookup of a step log table.

I believe you already have a self relation on team name, yes?

You can make use of that.

Firstly, add a RowID column if you don’t already have one.
Next, add a single value column that takes the first RowID via the multi relation.
Then an if-then-else column:

  • if RowID is single value RowID, then true

This should give you a column with one true row for each team, which you can use as a filter on your inline list.


I actually ended up setting up a Steps Log even though I didn’t really want the extra rows because I was able to provide a better user experience that way. But I set it up as you instructed and it’s working now. Thanks!

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.