What % of CLOSED questions are later edited? (Monthly)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

select 
  eomonth(closeddate) as ClosedYear,
  format(count(*),'#,##0') as [#ClosedQuestions],
  format(1.0*sum(Score)/count(*),'0.0') as [Avg Score],
  format(sum(case when not lasteditdate is null then 1 else 0 end),'#,##0') as [#Edited],
  format(sum(case when lasteditdate>closeddate then 1 else 0 end),'#,##0') as [#Edited After Close],
  format(1.0*sum(case when lasteditdate>closeddate then 1 else 0 end) / count(*),'0.0%') as [%Edit After Close]
from posts
where closeddate is not null and posttypeid=1
group by eomonth(closeddate)
order by eomonth(closeddate)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results