If you're experiencing issues with week 53 in Zendesk reports, it's due to the overlap of the end of one year and the start of another. A workaround is to create a custom attribute using the formula WEEKYEAR([Ticket Created - Date]).
This custom attribute, used alongside the default Ticket Created - Week of Year attribute, helps resolve the issue by correctly categorizing the weeks across the year transition.
To sort months in chronological order in Zendesk reports, you need to adjust the order of attributes. By default, Explore sorts month values from January to December. However, if you want to display months in chronological order for a specific…
To display months in reverse chronological order in Zendesk reports, you can use the Result manipulation feature. Navigate to Result manipulation > Sort and select the Z-A option. This will arrange the months so that the most recent month appears…
Yes, you can shorten month names in Zendesk reports by adjusting the truncation settings. Go to Chart configuration > X axis and set the Truncation (characters) to 8. This will abbreviate the month names, making your report more concise and easier…
To sort a rolling 6 months in Zendesk reports with the most current month on the left, use the Result manipulation feature. Ensure that the Months are under the Columns portion of your query, then go to Result manipulation > Sorts and choose the…