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 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 ap.CreationDate
order by ap.CreationDate
-- and ap.AnswerCount = 0

Enter Parameters

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