Answer rate over time

3

Please login or register to vote for this query.

(click on this box to dismiss)

Server Fault

Q&A for system and network administrators

select y = year(CreationDate), 
coalesce(count(case when AnswerCount > 0 then 0 end)*100/count(*), 0) as 'Answer Rate', 
count(*) as 'Question Count',
coalesce(count(case when AnswerCount = 0 and ClosedDate != 0 then 1 end)*100/count(*), 0) as 'Closure Rate'
from Posts
-- where ap.CreationDate > Convert(datetime, ##startdate:string##)
group by year(CreationDate)
order by year(CreationDate)
-- and ap.AnswerCount = 0

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results