# 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? – Michael K Feb 17 '12 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. – Morons Feb 17 '12 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. – yannis Feb 17 '12 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? – Morons Feb 17 '12 at 16:08
• @Morons In general, quality > quantity. – Adam Lear Feb 17 '12 at 16:09
• @Anna, What metric (If not Question Score) can i use to measure quality? – Morons Feb 17 '12 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. – Michael K Feb 17 '12 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? – yannis Feb 17 '12 at 16:16
• Ok, I understand.. For you, there is no evidence (or metric) that will is valid. – Morons Feb 17 '12 at 16:27
• >>Why are more questions automatically a good thing : Simply because participation is the life blood of any social site. – Morons Feb 17 '12 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. – Morons Feb 17 '12 at 16:31
• @Morons Thankfully Programmers is a Q&A site, not a social site... – yannis Feb 17 '12 at 16:31
• @Yannis But it is and was always meant to be. codinghorror.com/blog/2011/12/… – Morons Feb 17 '12 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. – Morons Feb 17 '12 at 16:40