A plot of upvotes on a post more than 10 days old over time. Only interesting in graph tab.
Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
declare @recentDaysExcluded int = 10
ROW_NUMBER() OVER (ORDER BY v.CreationDate) [Upvotes]
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