Participation value ratios

8

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

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

with Data as (

    select Users.Id as UserId,
           DisplayName,
           Reputation,
           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 Users, Posts, Votes
    where Users.Id = Posts.OwnerUserId
      and Votes.PostId = Posts.Id
      and Votes.VoteTypeId in (2, 3)
      and Posts.PostTypeId in (1, 2)
      and Users.Reputation >= 150
    group by Users.Id,
             Users.DisplayName,
             Users.Reputation,
             Users.UpVotes,
             Users.DownVotes
    
    )

select UserId  as [User Link],
       Reputation, GiveUp, GotUp, GiveDown, GotDown,
       (GiveUp - GiveDown) - (GotUp - GotDown) as ValueAdd,
       AnswersGiven,
       AnswerReplies,
       QuestionsAsked,
       Accepts,
       case when QuestionsAsked = 0
          then 1.0
          else Accepts / Cast(QuestionsAsked as NUMERIC(10,2))
       end as AcceptRatio,
       case when AnswerReplies = 0
          then 1.0
          else (GiveUp + GiveDown) / Cast(AnswerReplies as NUMERIC(10,2))
       end as VoteRatio
from Data

Enter Parameters

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