Create Sunday to Saturday Week Report in Zendesk Explore
How can I create a report with a Sunday to Saturday week in Zendesk Explore?
To create a report with a Sunday to Saturday week in Zendesk Explore, you need to set up a Standard calculated attribute. This attribute will ensure your data is reported by week, starting on Sunday.
To do this, go to Explore, click the reports icon, and then select 'New report'. Choose the 'Support - Tickets' dataset and start your report. From the Calculations menu, select 'Standard calculated attribute' and enter the formula:DATE_FORMAT(START_OF_WEEK_SUNDAY([Ticket created - Date]),"YYYY-MM-DD"). Name your attribute, for example, 'Ticket created - Sunday-Saturday', and save it. This attribute will now display the start date of the week, which is the Sunday of that week. For more details, check theoriginal link.
More related questions
Can I filter Zendesk Explore data for the previous week starting on Sunday?
Yes, you can filter Zendesk Explore data for the previous week starting on Sunday using the default 'Ticket Created - Date' filter. Navigate to the 'Advanced' section and select '7 Days in the Past' to '2 Days in the Past'. If you run this on a…
How do I report on tickets created from Monday to Monday in Zendesk Explore?
To report on tickets created from Monday to Monday in Zendesk Explore, you can modify the calculated attribute. Use the formulaLEFTPART(STARTOFWEEK_MONDAY([Ticket created - Date]),10)to adapt the attribute for a Monday start. Additionally, you…
Is it possible to customize a report to use a Wednesday to Tuesday week in Zendesk Explore?
Yes, you can customize a report to use a Wednesday to Tuesday week in Zendesk Explore. While the default setting might be different, you can adjust the calculated attributes to fit your desired week structure. For detailed instructions, refer to…
What permissions are needed to create a Sunday to Saturday week report in Zendesk Explore?
To create a Sunday to Saturday week report in Zendesk Explore, you need to have Editor or Admin permissions. These permissions allow you to access the necessary features in Explore to create and modify reports. Additionally, you need to be on the…
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.
