Change Details

Requested report breakdowns are on T171007 A new report: * number of cases (total) * number of cases (with marked resolutions) * how many cases over the same admins intervening — List of admins and Number of cases they have participated (CSV file) * how many cases (if any) were filed by the same person — List of users with number of cases they have filed if it was more than 1 * was there a popular day for filing cases? — distribution of cases opened on calendar date, distribution of cases open on day-of-week * what is the average time line of a case? (meaning how many days from open to archived) — Calculate AVG interaction time in a case (Get time difference between signatures and calculate AVG ) * what was the shortest timeline for a case? — Get dates in resolved cases and find out which one was resolved fastest * what was the longest timeline for a case? — Get dates in resolved cases and find out which one took longer to resolve * what was the largest case- in terms of people weighing in? —Will it work to get the case with the largest number of unique signatures?

Report 1: * number of cases (total) * number of cases (with marked resolutions) * numbers of cases that include keywords (harass, hound or stalk, coi, 3RR) — break out by each keyword * how many cases over the same admins intervening — List of admins and Number of cases they have participated (CSV file) * how many cases (if any) were filed by the same person — List of users with number of cases they have filed if it was more than 1 * was there a popular day for filing cases? — distribution of cases opened on calendar date, distribution of cases open on day-of-week * what is the average time line of a case? (meaning how many days from open to archived) — Calculate AVG interaction time in a case (Get time difference between signatures and calculate AVG ) * what was the shortest timeline for a case? — Get dates in resolved cases and find out which one was resolved fastest * what was the longest timeline for a case? — Get dates in resolved cases and find out which one took longer to resolve * what was the largest case- in terms of people weighing in? —Will it work to get the case with the largest number of unique signatures? Report 2: * Number of cases started, determined by the number of h2 sections with an initial signature on or between April 1 to May 31 2017. * Number of unique users (as determined by signatures?) * Number of unique admins (as determined by signatures, crossreffed with the admin table?)

Requested reReport breakdowns are on T1710071: A new report: * number of cases (total) * number of cases (with marked resolutions) * numbers of cases that include keywords (harass, hound or stalk, coi, 3RR) — break out by each keyword * how many cases over the same admins intervening — List of admins and Number of cases they have participated (CSV file) * how many cases (if any) were filed by the same person — List of users with number of cases they have filed if it was more than 1 * was there a popular day for filing cases? — distribution of cases opened on calendar date, distribution of cases open on day-of-week * what is the average time line of a case? (meaning how many days from open to archived) — Calculate AVG interaction time in a case (Get time difference between signatures and calculate AVG ) * what was the shortest timeline for a case? — Get dates in resolved cases and find out which one was resolved fastest * what was the longest timeline for a case? — Get dates in resolved cases and find out which one took longer to resolve * what was the largest case- in terms of people weighing in? —Will it work to get the case with the largest number of unique signatures? Report 2: * Number of cases started, determined by the number of h2 sections with an initial signature on or between April 1 to May 31 2017. * Number of unique users (as determined by signatures?) * Number of unique admins (as determined by signatures, crossreffed with the admin table?)