A customer may require a report that displays the activity their team has done on tickets on a specific day i.e. tickets that received a post on a specific day.
The KQL query below will generate a report of all tickets that have received a post today:
'Tickets.Ticket ID', 'Tickets.Creation Date' , 'Tickets.Subject','Tickets.Type','Tickets.Status', 'Ticket Posts.Full Name' as 'Staff'
'Ticket Posts.Creation Date' =Today() AND 'Ticket Posts.Creator' = 'Staff'
'Ticket Posts.Creation Date' filter can be customized accordingly to specify a given date.
Run the KQL query in Kayako Reports. You should see an output similar to the following: