Passive reputation plot

3

Please login or register to vote for this query.

(click on this box to dismiss)

A plot of upvotes on a post more than 10 days old over time. Only interesting in graph tab.

Ask Ubuntu

Q&A for Ubuntu users and developers

declare @recentDaysExcluded int = 10

select
  i.VoteDate [Date],
  max(i.Upvotes) [Upvotes]
from (  
  select  
    v.CreationDate [VoteDate],
    ROW_NUMBER() OVER (ORDER BY v.CreationDate) [Upvotes]
  from 
    votes v 
  inner join 
    Posts p 
  on v.PostId=p.id 
  where 
    p.OwnerUserId=##UserId## 
    and v.VoteTypeId = 2
    and datediff(day, p.CreationDate, v.CreationDate) > @recentDaysExcluded
    and p.PostTypeId = 2
) i group by i.VoteDate order by i.VoteDate

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results