| | 248 | |
| | 249 | = Ticket kills and undead = |
| | 250 | |
| | 251 | Kill rate (closure) for support in past 7 days |
| | 252 | {{{ |
| | 253 | #!SQLTable |
| | 254 | SELECT COUNT(DISTINCT(ticket)) as count, author |
| | 255 | FROM ticket_change, ticket |
| | 256 | WHERE ticket_change.time > UNIX_TIMESTAMP() - (86400 * 7) |
| | 257 | AND author in ('jwigglesworth', 'ctsai', 'hinojosa') |
| | 258 | AND ticket.id=ticket_change.ticket |
| | 259 | AND field='status' |
| | 260 | AND oldvalue!='closed' |
| | 261 | AND newvalue='closed' |
| | 262 | GROUP BY author ORDER BY count DESC; |
| | 263 | }}} |
| | 264 | |
| | 265 | Revive rate (closed -> open status) |
| | 266 | {{{ |
| | 267 | #!SQLTable |
| | 268 | SELECT COUNT(DISTINCT(ticket)) as count, author |
| | 269 | FROM ticket_change, ticket |
| | 270 | WHERE ticket_change.time > UNIX_TIMESTAMP() - (86400 * 7) |
| | 271 | AND author in ('jwigglesworth', 'ctsai', 'hinojosa') |
| | 272 | AND ticket.id=ticket_change.ticket |
| | 273 | AND field='status' |
| | 274 | AND oldvalue='closed' |
| | 275 | AND newvalue!='closed' |
| | 276 | GROUP BY author ORDER BY count DESC; |
| | 277 | }}} |
| | 278 | |
| | 279 | Kill rate for everyone in past 7 days: |
| | 280 | {{{ |
| | 281 | #!SQLTable |
| | 282 | SELECT COUNT(DISTINCT(ticket)) as count, author |
| | 283 | FROM ticket_change, ticket |
| | 284 | WHERE ticket_change.time > UNIX_TIMESTAMP() - (86400 * 7) |
| | 285 | AND ticket.id=ticket_change.ticket |
| | 286 | AND field='status' |
| | 287 | AND oldvalue!='closed' |
| | 288 | AND newvalue='closed' |
| | 289 | GROUP BY author ORDER BY count DESC; |
| | 290 | }}} |
