Common Queries

Sometimes other people on the team want to know certain statistics. To that end, this wiki page can act as a staging area for common queries until we reach a point that we can inject them into a team-facing GUI.

Example Query: Number of Non-IDEO users

User.where(User.arel_table[:email].does_not_match('%ideo%')).count

We also have more queries here: https://data.heroku.com/dataclips