Get this information in as many reports as sane and efficient:
* 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?
* 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?)