1. Kayako Download customers: we will continue to develop and support Kayako Download beyond July 2017, alongside the new Kayako for existing customers.

    Find out more.

  2. The forum you are viewing relates to Kayako Classic. If you signed up or upgraded to the new Kayako (after the 4th July 2016), the information in this thread may not apply to you. You can visit the forums for the new Kayako here.

KQL to count AVG length of staff reply (Ticket Posts.Contents)

Discussion in 'Kayako reports (Kayako Classic)' started by pavelsr, Feb 27, 2017.

  1. pavelsr

    pavelsr New Member

    Hi,

    Need to check which staff writing most detailed answers.

    Can someone help me with writing KQL ?

    I did an expression like

    SELECT AVG(LENGTH('Ticket Posts.Contents')), 'Users' FROM 'Tickets' WHERE 'Tickets.Resolved Date' <= Today() ORDER BY COUNT(*) DESC MULTIGROUP BY 'Tickets.Owner'

    But it doesn't work properly.

    I assume it's because there is no LENGTH function, or 'Ticket Posts.Contents' return an array so AVG(LENGTH(..)) can't handle with it fine or maybe I need to use 'Ticket Audit Logs' source...

    Any suggestion is appreciated.
     

Share This Page