# More evidence that we are going downhill [duplicate]

Possible Duplicate:
Are we Going down hill?

In my last post a few people pointed out the that decline in average score and question count was not a good metric for showing the decline of this site.. So here is some additional evidence.

I Basically classified every question as Good, Bad or Ok
Good= A score >1 and Open

Ok= A score =1 and Open

Bad= A score <0 or Closed

Here is The Graph (Including a Line for total)

Here is the SQL:

``````Select
week.week
,good.cnt as Good
,ok.cnt as ok
from
(select distinct
CAST(year(p.CreationDate) as char(4))+'-'+CAST(DATEPART(wk,p.CreationDate) as char(2)) as week
from Posts p
join
(select
CAST(year(p.CreationDate) as char(4))+'-'+CAST(DATEPART(wk,p.CreationDate) as char(2)) as week
,count(1) as Cnt
from Posts p
where score>1 and Closeddate is Null
group by   year(p.CreationDate),DATEPART(wk,p.CreationDate)
) good on good.week=week.week
join
(select
CAST(year(p.CreationDate) as char(4))+'-'+CAST(DATEPART(wk,p.CreationDate) as char(2)) as week
,count(1) as Cnt
from Posts p
where score=0 and Closeddate is Null
group by   year(p.CreationDate),DATEPART(wk,p.CreationDate)
) ok on ok.week=week.week
join
(select
CAST(year(p.CreationDate) as char(4))+'-'+CAST(DATEPART(wk,p.CreationDate) as char(2)) as week
,count(1) as Cnt
from Posts p
where score<0 or Closeddate is not Null
group by   year(p.CreationDate),DATEPART(wk,p.CreationDate)
order by week.week
``````
• Clearly the site is dead. Wait, does that make this a ghost account? Commented Feb 17, 2012 at 15:56
• @Michael, I post these things because I want help make this place better. And the first step in doing that is smacking people out of denial. Commented Feb 17, 2012 at 16:00
• @Morons The graph actually proves we are getting better, moving away from the troublesome early days when every crappy post was ridiculously upvoted... Help us clean up those early posts and the numbers will be quite different. Commented Feb 17, 2012 at 16:03
• @Yannis is it also good that out total question count is Down 30% from One year ago? Please tell me, what metric will be good enough evidence for you? Commented Feb 17, 2012 at 16:08
• @Morons In general, quality > quantity.
Commented Feb 17, 2012 at 16:09
• @Anna, What metric (If not Question Score) can i use to measure quality? Commented Feb 17, 2012 at 16:11
• I don't mind a drop of even that much or more if the "questions" lost are the ones we are constantly closing. What are we losing? Nothing. Commented Feb 17, 2012 at 16:12
• @Morons There are quite a few reasons why we would be getting less questions: 1) New SE sites, that are better homes for quite a few questions we used to accommodate, 2) Less crap finds it's way here from Stack Overflow, 3) We are doing a far better job cleaning up our own crap... Why are more questions automatically a good thing? Commented Feb 17, 2012 at 16:16
• Ok, I understand.. For you, there is no evidence (or metric) that will is valid. Commented Feb 17, 2012 at 16:27
• >>Why are more questions automatically a good thing : Simply because participation is the life blood of any social site. Commented Feb 17, 2012 at 16:28
• @Michael both Quality AND Quantity are going down. These two should not be at odds with each other. The goal should be to increase both. Commented Feb 17, 2012 at 16:31
• @Morons Thankfully Programmers is a Q&A site, not a social site... Commented Feb 17, 2012 at 16:31
• @Yannis But it is and was always meant to be. codinghorror.com/blog/2011/12/… Commented Feb 17, 2012 at 16:34
• @All I'm not looking to argue with anyone, I simply think there is allot of room for improvement here.. And we should consider what those improvements should be. There is an absolutely culture of complacency here.. Any kind of negative talk if highly discouraged. I personally think it one of the biggest problems we have. Commented Feb 17, 2012 at 16:40