Determine second position

Ask for Help
1

hi,

I have a use case where participants will get rewards points based on their quiz result. In the data editor I can do a roll up and get the maximum to determine the leader (winner).

How can I determine the second and third position in data editor. I know in the inline list I can display with sorting but this is not useful for my usage.

Appreciate suggestions.

2

If you have the results in the Sheets then you can use this.

1 Like
3

I did calculations in Glide Editor

1 Like
4

Is there much difference between the maximum and minimum?

5

It is a quiz, so the differences will depend on response. however, the range is between 1 to 20.

6

Maybe the best is still to bring the calculated data back into Googlesheets
Is there a way to write from the data editor to a column in sheets?

Thank you.

7

Here Iā€™m thinking fastā€¦

1- Find the maximum value (winner) using a Rollup
2- Subtract this max value to other values and look for lowest result >0 now, it is your 2nd place
3- Subtract the lowest value >0 belonging to step 2 to other values and look for lowest result >0 again, you will have the 3rd place.

Of course, you will have to use new columns to Rollup and If-Else-Then operations.

I hope it helps you!

Saludos @Mns_Glide

7 Likes
8

got it working @gvalero
thank you so much.

1 Like
9

Hi,
In continuation with this question. Now I have a situation where there can be many people with the same results or points and hence we will have many people showing up in first place.

I would like sort out where we factor in the timingā€¦so first one to come in highest points in the fastest time will be winnerā€¦then all the rest will push to second and thirdā€¦so basically even if we have 5 people with same highest points, only the fastest time will receive the honor of being first, second and thirdā€¦

Suggestions please.
Thank you.

10

I think this is getting a bit complex to make workarounds in Glide as we donā€™t have a native ā€œrollup for rankingā€ as you have seen. If youā€™re willing to bring the data back to the Sheet, then I believe you can use SORT function to do that.

11

Indeed it is. just sorting out the three winners required a lot of logic in glide. hopefully these formulas will be available soon in glide.

1 Like