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?
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 ...
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.
I can imagine it can happen when the OP doesn't have enough reputation to upvote,
and the post gets overlooked by other users "...
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.
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
-------------------- ------- --------------- --------------------------
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).
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!
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.
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 single ...
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.
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 ...
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.
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.
CREATE TABLE #DatabaseTags (Name VARCHAR(100));
INSERT INTO #DatabaseTags
-- Top scored database ...
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, ...
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.
"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 ...
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
Stdev time to answer per tag
Stdev @ StackOverflow
Looks like the metric ...
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