What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 134 Stack Exchange communities.

I'm interested in how to communicate the value of a contribution to StackExchange sites to others who know nothing about StackExchange. I thought that one index would be to have a total view count of questions and answers that a user has contributed to.

I've had a look around http://data.stackexchange.com/ but I couldn't find anything that does that.

Thus, my question:

Is there any way to extract the total number of views a set of questions has received, where that set is defined as those that a user has either contributed an answer or the question?

share|improve this question
    
This would definitely be possible, all questions track their view counts over in the sidebar. So it would just be a matter of writing a query to extract this information. For that, you'll need someone who knows SQL, someone other than me! Otherwise, you'll have to add them up by hand. –  Cody Gray May 24 '12 at 9:01
    
It is good to know that it is possible. I'll see if I can tweak an existing one. –  Jeromy Anglim May 24 '12 at 10:49

1 Answer 1

View count per user would be the query that answers your question.

select top 1000 u.id as [User Link]
, sum(ViewCount) as [Total Views]
from Posts p 
inner join users u on u.id = p.owneruserid
group by u.id
order by [Total Views] desc
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .