Skip to content

Instantly share code, notes, and snippets.

@jldugger

jldugger/average ticket age

Last active August 29, 2015 14:05
Show Gist options
  • Save jldugger/444e377c956459acf6ea to your computer and use it in GitHub Desktop.
Save jldugger/444e377c956459acf6ea to your computer and use it in GitHub Desktop.
Download ZIP
Raw
average ticket age
SELECT DATE(FROM_UNIXTIME(AVG(UNIX_TIMESTAMP(Created))))
FROM Tickets
WHERE Status NOT IN ('rejected','stalled','deleted','resolved')
AND Queue IN (27);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment