Some users of Kayako Classic may encounter difficulty when trying to generate a report that reflects data from specific dates across multiple years. For instance, a user may want to create a report showing the total tickets opened for the last 4 Martin Luther King Jr. (MLK) days, which occur around January 15th each year. The challenge lies in adjusting the parameters in the Kayako Query Language (KQL) to reflect this specific date range across multiple years, rather than just a single specific day.
To generate a report in Kayako Classic that shows the total tickets opened for the last 4 MLK days, you need to modify the KQL query as follows:
- Instead of using the =TODAY() function in your query, substitute it with IN ('YYYY-MM-DD', 'YYYY-MM-DD') where 'YYYY-MM-DD' represents the dates for the MLK days for the last 4 years.
- Preface the criteria with 'SELECT COUNT(*) FROM' to get the counts of the tickets.
This will allow you to generate a report that reflects the total tickets opened on the MLK days for the last 4 years.
By modifying the KQL query in Kayako Classic, users can generate reports that reflect data from specific dates across multiple years. This involves substituting the =TODAY() function with specific date values and prefacing the criteria with 'SELECT COUNT(*) FROM' to count the tickets.
Can I use this method to generate reports for other specific dates across multiple years?
Yes, you can substitute the MLK dates with any other specific dates you need to generate a report for.
Can I use this method to count other types of data, not just tickets?
Yes, you can replace 'tickets' with any other data type you need to count in your report.
Can I use this method in other versions of Kayako, not just Kayako Classic?
This method is specifically for Kayako Classic. Other versions may require different steps.