Participation value ratios


Please login or register to vote for this query.

(click on this box to dismiss)

Pull out the vital statistics of the key figures on your site.<br> 2 special columns: ValueAdd and Feedback<br> ValueAdd is the net-positive voting behaviour (upvotes less downvotes plus accepts given as well as any upvotes on answers to their questions - questions provide an opportunity for value to be added because answers can happen)<br> FeedbackRatio is the number of voting-opportunities taken over the number of voting occasions expected to be taken (expected to vote n all answers to your own questions, and all questions you answer, as well as an accept for each question you ask).<br> The rank is the order-by Feedback

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

with Data as (

    select UserId as [User Link],
           Upvotes as GiveUp,
           DownVotes as GiveDown,
           sum (case when AcceptedAnswerId is null then 0 else 1 end) as Accepts,
           sum (case when PostTypeId = 1 then 1 else 0 end) as QuestionsAsked,
           sum (case when PostTypeId = 2 then 1 else 0 end) as AnswersGiven,
           sum (AnswerCount) as AnswerReplies,
           sum (case when VoteTypeId = 2 then 1 else 0 end) as GotUp,
           sum (case when VoteTypeId = 3 then 1 else 0 end) as GotDown
    from Posts, Users, Votes
    where UserId = OwnerUserId
      and VoteTypeId in (2, 3)
      and PostTypeId in (1, 2)
      and Reputation >= 150
    group by UserId, DisplayName, Reputation, UpVotes, DownVotes

select *
from Data

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results