% of questions edited after close (graph based on Date Asked)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

select 
  eomonth(creationdate) as Asked,
  1.0*sum(case when lasteditdate>closeddate then 1 else 0 end) / count(*) as [%Edit After Close]
from posts
where closeddate is not null and posttypeid=1
group by eomonth(creationdate)
order by eomonth(creationdate)

Enter Parameters

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