Get this information in as many reports as sane and efficient:
[x] number of cases (total)
[x] number of cases (with marked resolutions)
[x] numbers of cases that include keywords (harass, hound or stalk, coi, 3RR) — break out by each keyword
[x] how many cases over the same admins intervening — List of admins and Number of cases they have participated (CSV file)
[x] 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
[x] 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?
[x] Number of unique users (as determined by signatures?)
[x] Number of unique admins (as determined by signatures, crossreffed with the admin table?)