# Leaderboard **URL:** https://community.glideapps.com/t/leaderboard/74784 **Category:** Ask for Help **Created:** [July 10, 2024, 1:31pm UTC](https://community.glideapps.com/t/leaderboard/74784 "2024-07-10T13:31:55Z") **Posts on this page:** 10 **Page:** 1
### Author: ![Trustin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trustin/32/88217_2.png) [@Trustin](https://community.glideapps.com/u/Trustin) #### Post date: [July 10, 2024, 1:31pm UTC](https://community.glideapps.com/t/leaderboard/74784/1 "2024-07-10T13:31:55Z")
Hi Gliders~ I want to create a leaderboard to filter and display users with the top ratings. Then I realised those values are in the user profile data, I could only read my on rating. What should I do? Are there alternatives to reading those values? ---
### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager) #### Post date: [July 10, 2024, 1:34pm UTC](https://community.glideapps.com/t/leaderboard/74784/2 "2024-07-10T13:34:49Z")
Store the ratings in a different table that isn’t under row ownership. ---
### Author: ![Trustin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trustin/32/88217_2.png) [@Trustin](https://community.glideapps.com/u/Trustin) #### Post date: [July 10, 2024, 1:38pm UTC](https://community.glideapps.com/t/leaderboard/74784/3 "2024-07-10T13:38:09Z")
Yeah, I have a table which tracks certain actions overtime and add a row with player data, so I am adding additional information to the row. And use a filter to display the top 3 ratings in a collection list. ---
### Author: ![Trustin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trustin/32/88217_2.png) [@Trustin](https://community.glideapps.com/u/Trustin) #### Post date: [July 10, 2024, 1:42pm UTC](https://community.glideapps.com/t/leaderboard/74784/4 "2024-07-10T13:42:49Z")
Also how do you deal with duplicated rows with the same user but a different value stored at different time? ---
### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager) #### Post date: [July 12, 2024, 3:46pm UTC](https://community.glideapps.com/t/leaderboard/74784/5 "2024-07-12T15:46:39Z")
Do you want to Sum all the different values for the same user? ---
### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh) #### Post date: [July 13, 2024, 12:05am UTC](https://community.glideapps.com/t/leaderboard/74784/6 "2024-07-13T00:05:40Z")
> [@Trustin](#): > > Also how do you deal with duplicated rows with the same user but a different value stored at different time? Can you show us how you’re structuring your data? Are we talking about a records table where a user can have different records at different times? What do those records tell you? ---
### Author: ![Trustin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trustin/32/88217_2.png) [@Trustin](https://community.glideapps.com/u/Trustin) #### Post date: [July 13, 2024, 1:20am UTC](https://community.glideapps.com/t/leaderboard/74784/7 "2024-07-13T01:20:49Z")
Here’s my insight table. I have a Add a row Action whenever user take a specific action. Currently I am passing in details from user profile like their name, ratings and avatar to this table. Then I use a query to filter this table with rows that have ratings greater than 2.5 and also read the rows that are active within 3 days. I use a collection to display the Top Hoarded column and limit the number of items to 3. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cf6897805d5f6de1872a47a0c59061805308ed2f.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/7965565ab31987479e08e9b08d09dbc2ca18799a.png) ---
### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy) #### Post date: [July 13, 2024, 3:40am UTC](https://community.glideapps.com/t/leaderboard/74784/8 "2024-07-13T03:40:35Z")
> [@Trustin](#): > > Currently I am passing in details from user profile like their name, ratings and avatar to this table. Why wouldn’t you just store the PlayerID and then use a relation + lookups to get those other values? What happens if a Player changes their name or avatar? What happens when a Player rating changes? ---
### Author: ![Trustin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trustin/32/88217_2.png) [@Trustin](https://community.glideapps.com/u/Trustin) #### Post date: [July 13, 2024, 3:41pm UTC](https://community.glideapps.com/t/leaderboard/74784/9 "2024-07-13T15:41:02Z")
I tried with Player email and relation, but it since their information is secured in the user profile data, it was only able to display my information lol. ---
### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh) #### Post date: [July 13, 2024, 10:48pm UTC](https://community.glideapps.com/t/leaderboard/74784/10 "2024-07-13T22:48:33Z")
So there’s information in the Users table that you want to protect from other users, but all users need to be able to view each other’s name and image?