Display Start Date of Week in Zendesk Reports
How can I display the start date of the week instead of the week number in Zendesk reports?
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 open the formula editor. Paste the following formula:DATE_FORMAT(START_OF_WEEK_MONDAY([Ticket created - Date]),"YYYY-MM-dd"). Click 'Save' and add this new attribute to your report.
You can replaceSTART_OF_WEEK_MONDAYwithSTART_OF_WEEK_SUNDAYorSTART_OF_WEEK_SATURDAYdepending on your preferred start day of the week. For more details, check theoriginal link.
More related questions
What should I do if the date format in my Zendesk report changes unexpectedly?
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 resolved…
How can I sort dates correctly in Zendesk reports?
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…
Can I use a custom start day for the week in Zendesk reports?
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…
How can I apply the start date of the week formula to call data in Zendesk?
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 -…
Interested indeflectingover 70% of your Zendesk support tickets?
Zendesk Support Tickets
Zendesk Messaging (live chat)
Join1,000+ companies reducing their support costs and freeing up support agents for more important work
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
Reduce support costs.Spend more time on customer success.
