I only have a score and entrant field, but want to assign a rank based on the score value. Where scores are equal, the rank is equal, but then would skip over the next n ranks to "realign" the rank.
| rank | score | entrant |
|---|---|---|
| 1 | 100 | "Bob" |
| 1 | 100 | "Jon" |
| 3 | 90 | "Jen" |
| 4 | 80 | "Jim" |
At the moment I am adding the rank field with JavaScript after I get the results, but want to know if it's possible to do this with the groq query?
