What % of CLOSED questions are later edited? (Monthly, excluding User 'Community')

0

Please login or register to vote for this query.

(click on this box to dismiss)

re: https://meta.stackoverflow.com/questions/371910/why-did-questions-stop-getting-edited-after-closing-in-2013

Drupal Answers

Q&A for Drupal developers and administrators

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],
 */ 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 and owneruserid=-1
group by eomonth(closeddate)
order by eomonth(closeddate)

Enter Parameters

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