Report 1: All cases from October 1 2016 — September 30 2017
A large report, such as from T178536. From October 1 2016 — September 30 2017
| Data | Type | Status |
|---|---|---|
| Title | string | No change from previous report |
| URL | string | No change from previous report |
| Opened date | timestamp | No change from previous report |
| Last signature date | timestamp | I believe this is currently parsed, but not yet reported |
| Case length¹ | integer | No additional parsing needed |
| Author | string | No change from previous report |
| Total Users | integer | No change from previous report |
| Total Admins | integer | No change from previous report |
| Bytes² | integer | Will require another parse of the wikitext |
| Diffs³ | integer | Will require another parse of the wikitext |
| Resolved | boolean | No change from previous report |
| Resolution | string | No change from previous report |
| Resolved By | string | No change from previous report |
Notes:
- Milliseconds between opened & last signature
- Bytes or characters for the entire case, removing signatures if possible
- The number of links in the entire case to diffs, formatted either via {{Diff* or https://en.wikipedia.org/*&diff=* or [[Special:Diff/*
From this report, we will be able to filter to determine:
- Average length of threads by time (for total, closed, or not closed)
- Average length of threads by bytes (for total, closed, or not closed)
- Does reporting diffs help/hurt a case receive closure?
- Outliers (long threads, short threads, unanswered threads)