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 unique users (as determined by signatures?)
- Number of unique admins (as determined by signatures, crossreffed with the admin table?)