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.

count() issue

Discussion in 'Kayako reports (Kayako Classic)' started by Lenny Wolf, Jul 13, 2017.

  1. Lenny Wolf

    Lenny Wolf New Member

    Hello
    I have a question regarding the following KQL query:
    "
    SELECT Count ('Ticket Audit Logs.Action') AS ActionCount FROM 'Ticket Audit Logs' WHERE 'Ticket Audit Logs.Creation Date' = Yesterday() AND 'Ticket Audit Logs.Full Name' IN ('Peter Fox, 'Jimmy Choo') GROUP BY 'Ticket Audit Logs.Full Name' ORDER BY COUNT('Ticket Audit Logs.Action') DESC
    "

    The employee Jimmy Choo didn't work yesterday, therefore his name will not be listed in the outcome of this query, since he didn't have any ticket-activity.
    Is there a way to also show employees who had no activity in the result?
    Any help would be highly apreciated.
    regards
    L
     

Share This Page