First Reply Time - Average

1 Comments

  • Graeme Carmichael
    Comment actions Permalink

    Bastiaan

    It may be easier to use the median to balance outside values from your report?

    I have not created many ranking reports, but I believe you can use a custom measure to exclude the top 10% as follows:

    SELECT IFNULL( (SELECT #Tickets WHERE BOTTOM (90%) IN (SELECT First Reply Time BY Ticket ID)),0)

    Now create a numeric filter, defined as:

    • What do you want to filter > Ticket ID
    • Select metric and range> NewCustomMetric is greater than 0

    Hope that is ok.

    0

Please sign in to leave a comment.

Powered by Zendesk