Leader Board

[chrismytton]

• First iteration - just count number of responses per person, limit to 10 or whatever
• Second iteration - give point for completed terms and countries
• Third iteration - work over specific time periods so we can tell who's the top 10 for the day

[chrismytton]

For the first iteration we can just use something like:

SELECT count(*) as count, name
  FROM responses
  INNER JOIN users on responses.user_id = users.id
  GROUP BY name
  ORDER BY count desc
  LIMIT 10;

[chrismytton]

Or using Sequel (this project's ORM):

Response.join(:users, id: :user_id)
  .group_and_count(:name)
  .order(Sequel.desc(:count))
  .limit(10)

[tmtmtmtm]

We should experiment with different options, but perhaps a basic score of 1 point per card; a level completion bonus of an extra point per card in that level; a country bonus of another extra point for every card in the country (i.e. each card scores 1 point by default, or 2 points if you've completed the level it appears in, or 3 points if you've completed the country)

Once we start combining the data to send back (or if we get official data later), you should also lose points for a wrong answer.

[tmtmtmtm]

The basic version is now live at http://www.gender-balance.org/leaderboard (though not linked from anywhere)

This will need some design love from @zarino, and probably some shiny text from @MyfanwyNixon to accompany it too.

[MyfanwyNixon]

Are you a Gender Balance whizz? Then you'll see your name right here.

[rankings]

Enjoy the fame... but don't rest on your laurels: other players could overtake you at any time!

button: [Get back to the game]

[zarino]

Closing since https://github.com/everypolitician/gender-balance/pull/197 includes the leaderboard on the homepage, rather than a page of its own.