I am trying to see the reply time for tickets with a certain tag. I have used tags before to filter tickets, but I am struggling when using facts instead of metrics. This is what I currently have:
SELECT IFNULL((SELECT MEDIAN(First reply time in minutes*60) WHERE Ticket Tag=created_by_agent),0)
The results are the sames as with my normal metric for first reply time, so I can tell that this metric is ignoring the "Where", but I cannot figure out what to do.
Thanks in advance for the help,
Please sign in to leave a comment.