Sorting repeating group by sum

Need help
1

Hey everyone!
I have been battling with this for more than a week and I am completely upset.
I am building a ranking. This ranking takes the data from a file that contains all the results (Players and Points):
PLAYER
Tom
Tom
Peter
Tom
POINTS
5
2
5
1
I would like to create a repeating group which groups the players and then orders them by the sum of their points, so the final output would be:
Tom - 8
Peter - 5

Any ideas???
I am able of showing the sum of the points and the players, but I am not able of sorting by this number :frowning:

2

I struggled with a similar issue.
Created a custom state of type List of Players.
Added another field named “Total points” to the Players datatype. On page load,
Make changes to a list of Players,
Total points= Search for players: each items Points:sum.
Adding all Players to the Custom state “List of players”
Using this custom states list of players to Display in the Repeating group.

3

Thanks, I am going to try. I will ask you for more help if needed!!

1 Like
4

More ideas on this???

5

Hi guys. This is not so difficult…

My database:

image

My result:

image
image869Ă—565 12 KB

So…

In the rank repeating group:

image
image834Ă—410 28.4 KB

image
image890Ă—645 55.4 KB

image
image890Ă—460 36.6 KB

Hope it help

6 Likes
6

Dude there is no words to thank you for this help…
So send me your paypal :rofl:

7

I am glad it helped! :joy:

Just giving back the help I also received here…
Pay in the future, as help for others :wink:

8

Thanks again mate…
Last question, how can I insert emojis like your picture?

9

Just copy and paste it in a text field :sweat_smile:

I use this site:

10

This topic was automatically closed after 70 days. New replies are no longer allowed.