To display the start date of the week instead of the week number in your Zendesk reports, you need to create a custom attribute. In the report builder, click the Calculations icon on the right sidebar and select 'Standard calculated attribute' to…
If the date format in your Zendesk report changes unexpectedly, it might be due to a bug or system update. Recently, there was an issue where the DATE_FORMAT function included a full timestamp instead of the expected format. This has been…
To sort dates correctly in Zendesk reports, ensure your custom attribute returns a numeric date value. If your dates are sorting alphabetically, adjust your formula to use the formatYYYY-MM-dd
. Then, change the display format via Chart…
Yes, you can set a custom start day for the week in Zendesk reports. In Explore, click the admin icon, then the account information icon. Under 'Start of the week', select your preferred start day and click 'Update account'. This will apply your…
To apply the start date of the week formula to call data in Zendesk, modify the existing formula to reference call dates. Replace[Ticket created - Date]
with[Call - Date]
in the formula: `DATEFORMAT(STARTOFWEEKMONDAY([Call -…