Answer rate over time


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(ap.CreationDate), coalesce(count(case when ap.AnswerCount > 0 then 1 end)*100/count(*), 0)
from Posts as ap
-- where ap.CreationDate > Convert(datetime, ##startdate:string##)
group by year(ap.CreationDate)
-- order by ap.CreationDate
-- and ap.AnswerCount = 0

Enter Parameters

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