15

Here's my re-creation of Grace Note's query. The numbers, as of 2014-01-16, are: Reputation Threshold # Users % of Avid Users Cumulative % of Avid Users -------------------- ------- --------------- -------------------------- 150 1095 51.7241 51.7241 200 793 37.4587 89.1828 ...


13

It is very exciting to get badges on Stack Exchange, but, how many badges are you one vote away from? Badges can be somewhat complicated to understand, but, sometimes you are just one vote away from that Enlightened.... but, were you the first answer? Are there badges you missed? Is there a vote you can make which will let someone else earn a badge? All ...


10

Occupy Code R3view A while back I had favorited this query for StackOverflow. Now that CR is on the SEDE, I wondered how we'd compare: How Rich Are the 1% (Active Users) With this week's data... SO's breakdown is: 27.54% to the 1% (1,610 users) 72.46% to the 99% CR's breakdown is: 17.33% to the 1% (11 users, 104,607 rep | average 9,509.72) 82.67% to ...


10

Naruto (accepted answer with zero score) Accepted answers without upvotes seem to be an anomaly: when would you accept an answer but not upvote it? I haven't yet experienced a situation where this would be reasonable. However, I can imagine it can happen when the OP doesn't have enough reputation to upvote, and the post gets overlooked by other users "...


9

Such a query could be beneficial if done responsibly. My concern is that it might encourage ad hominem voting. I suggest that you drop the u.Id column, and change a.Id to q.Id, so that you need to skim through all of the answers on the question before voting.


7

As an out-of-interest discussion about avid users, and avid user retentions... I modified 200_success's avid-user query to exclude users who are dormant. Consider this result: Avid Users of all time Reputation Threshold # Users % of Avid Users Cumulative % of Avid Users -------------------- ------- --------------- -------------------------- 150 ...


7

Some discussion about answer ratios, vote ratios, and other small-metric numbers was discussed in the 2nd monitor recently. This motivated the following report. This report cannot be run on the StackOverflow database - it times out but is OK to run on any of the other sites (the data volumes are much lower).


6

Here is a slightly different way to approach the lack of voting pointed out by @tomdemuyt: Questions with only zero-score answers Zero-vote answers on questions with no accepted answer, and all answers with at most zero score Please use these queries and do your part to upvote zombie answers!


6

I put together a Tag Answer Times query; looking at all the answers posted under the top 10 tags over the last 60 days, I was interested in knowing the hour of the day answers were posted. The query adds 1 to the hour when the minutes are > 30. By removing the date filter, I get this: Looks like the best time to ask a question is around 3PM UTC.


6

Tumbleweed Prevention Most of us probably know how it feels to have a question that gets very little attention. Imagine how it would be to get essentially no attention. No votes. No comments. Very few views. All you get is a Tumbleweed badge. Yay. Help prevent the "Tumbleweed" badge by giving the right questions some attention! A question with a ...


6

Generalist badge, and your progression Generalist is a badge that is awarded if you have a score of 15 for at least 20 of the top 40 tags on the site. Small print: The top-40 tags are ranked by counting the number of not-closed questions that have that tag. There needs to be more than 200 questions for all top-40 tags (Code Review Recently crossed this ...


5

Ripe zombies Open questions with answers, at least one answer having score 0, no answer having score > 0 (a.k.a. zombies ready for killing). If you have some spare votes burning your pockets, this could be a good place to put them.


5

Categorized lists of tags I took the top 500 tags and (with the help of a few fellow contributors) made some loosely categorized CREATE TABLE statements that you can drop into your SEDE queries and JOIN to the Tags table. Example usage: CREATE TABLE #DatabaseTags (Name VARCHAR(100)); GO INSERT INTO #DatabaseTags VALUES [...] GO -- Top scored database ...


5

Question/Answer ratio The answers-per-question ratio was not brought up as being a problem in the Grace Note Review, but it is a persistent 'concern' on Area-51. Currently CodeReview is at 1.8 answers/quesion, which is 'OK'. Area51 claims that 2.5 is a good ratio... So, how to improve? Well, the answer to that is to answer questions multiple times, but, you ...


5

It was asked: Anyone know how to formulate the voting data as a pivot: Here is a first stab at the critical voting factors for CodeReview since 1 Jan 2013. This does a pivot-table on the voting data, and plots the results as a graph over time.


4

"Call of Duty - We're on a mission" says, Your ammunition: 40 votes per day, unlimited answers. Every unanswered question is a zombie. Every unvoted good answer is a target. If one answers a question, it is encouraging to get at least one vote (or a comment about how to improve your answer); if you post and get no feedback at all, that's ...


3

Vote Analysis Compare year-to-year monthly votes, by type: Answer votes AcceptedByOriginator UpMod DownMod BountyClose Deletion Undeletion ModeratorReview ApproveEditSuggestion Question votes UpMod DownMod Favorite Close Reopen BountyStart BountyClose Deletion Undeletion ModeratorReview ApproveEditSuggestion TagWiki votes ApproveEditSuggestion ...


3

We've discussed Unsung Hero for Best of 2013. Here is some data to go with that: Unsung Heroes


3

Answers that elicited a "wow" comment from the original poster (I've sorted the results by ascending answer score, to help identify which good candidates to upvote.)


3

Time to Answer This query breaks down the average standard deviation of time to answer by month (questions' date asked), for the top 5 tags: Average time to answer per tag http://data.stackexchange.com/codereview/query/170387/time-to-answer#graph Stdev time to answer per tag Stdev @ StackOverflow Looks like the metric ...


3

FizzBuzz on FizzBuzz This one is just for fun! It returns all fizzbuzz questions, as well as performing FizzBuzz on several values related to the questions and users!


3

Bad Naruto (*) Selfie accepted answers with zero or negative score, when there are other answers with positive score. Such answers seem suspicious, and might even need moderator attention. Warning: these are potential bad Narutos. Legitimate false positives may exist. (*) Naruto (a hat in Winter Bash 2014): accepted answer with zero score


2

Code-only answers Code-only answers (also known as code dumps) don't make good code reviews in general, and require attention, to get improved, or possibly deleted.


1

Look for zombies by tag Note that you need to use quote marks in the tag field since it is VARCHAR. Like 'java', etc. Otherwise you'll get an error like "Invalid column: java".


1

For bragging rights ;-) Top answerers for each Tag (Credit to @rolfl)


Only top voted, non community-wiki answers of a minimum length are eligible