How to sort repeating groups that use grouped by:

[marketing1]

Hello everyone!

Has anyone a solution to sort a repeating group that’s using :grouped by in a way other than alphabetical?

I have now created an automatic leaderboard that updates every hour. To show :last item of a person’s leaderboard, GROUPED BY: is used. This means you only see the leaderboard alphabetically and not in descending order of their achievements. How can I fix this?

By the way, I am using the new Bubble table element for this.

[alex.esposito.1108]

You can add an aggregation then sort by that aggregation

[marketing1]

How does the sort work by aggregation?

This is the table right now:

[bonjour_17]

What do you want to group and display exactly?

Here is an example of how to use grouping and aggregations.

I have “Cards” in my database. (not very important what it is)

I want to make a table that will GROUP cards based on the day they were created. And for each day I want to AGGREGATE the group of cards and count how many was created.

Another representation of what is done :

Card A : created Monday
Card B : created Monday
Card C : created Monday
Card D : Created Tuesday
Card E : Created Thursday

First you GROUP by “Date” (you can also group by other type of fields like text or number)

So you get a table :
Monday : A / B / C
Tuesday : D
Wednesday : empty (if you tick the option “Do not skip empty groups”)
Thursday : E

And then you AGGREGATE. Basicaly you tell Bubble “For each GROUP, I want as a result the Count of how many things they are”

And you get a table :
Monday : 3
Tuesday : 1
Wednesday : 0 (if you tick the option “Do not skip empty groups”)
Thursday : 1

Note : as an output value in the dynamic fields, you’ll only see the result of the aggregations you’ll do. If you only group with no aggregation you won’t see anything there.