SELECT IF Ticket Status NOT IN ( , , ) THEN MAX(SELECT THIS - (SELECT Date (Ticket Created) BY Ticket Id)) ELSE AVG((SELECT Date (Ticket Solved) BY Ticket Id) - (SELECT Date (Ticket Created) BY Ticket Id)) END
If I try to report on this metric based on ticket priority overall though, the numbers don't look right.
I essentially want an average of all ticket ages per priority. I can select "Average > Of All Rows", but this doesn't necessarily provide me the data I'm looking for.
Please sign in to leave a comment.