Kayako Helpdesk Ticket Closure Report (Monthly)

Create a new report in Kayako Helpdesk with the following code to generate a report that will display the number of calls marked as "Resolved" within a calendar month. Change the bolded text to the month/year you wish to report on;

SELECT COUNT(*) AS Total FROM 'Tickets' WHERE 'Tickets.Is Resolved' = '1' AND 'Tickets.Resolved Date' = month(April 2013) GROUP BY X('Tickets.Resolved Date':Week), X('Tickets.Resolved Date':DayName), Y('Tickets.Department')