In this Explore recipe, you'll learn how to create a Standard calculated attribute that always reports on data by week with Sunday as the start of the week. By default, a user’s profile locale (set in the Language field in the user’s profile in Zendesk Support) determines the start of the week for that user.
Tip: You can change which day Explore considers to be the start of the week on an account-wide level. If you do that, the built-in Week of year attributes will use that day as the start, instead of the start of the week determined by the user’s profile. For details, see Setting the start of the week for reports and filters.
What you'll need
Skill level: Moderate
Time Required: 10 minutes
- Zendesk Explore Professional or Enterprise
- Editor or Admin permissions (see Giving agents access to Explore)
- Ticket data in Zendesk Support
Creating the attribute
- In Explore, click the reports (
) icon.
- In the Reports library, click New report.
- On the Select a dataset page, click Support > Support - Tickets, then click Start report. The report builder opens.
- From the Calculations (
) menu, click Standard calculated attribute.
- On the Standard calculated attribute page, enter or copy and paste the formula below into the attribute editor.
DATE_FORMAT(START_OF_WEEK_SUNDAY([Ticket created - Date]),"YYYY-MM-DD")
Tip: If you're working in a language other than English, to enter Explore formulas in your language, read the following article: How can I convert formulas from English into another language? - Give the attribute a name like Ticket created - Sunday-Saturday.
- When you are finished, click Save.
Keep in mind that this attribute is reporting on the week the ticket was created. If you need to report on the week the ticket was solved, edit the attribute above and replace [Ticket created - Date] with [Ticket solved - Date].
You can now use this attribute in your reports. The display format of this attribute will show the start date of the week (i.e. the date of the Sunday that represents the start of the week).
9 comments
Jess Hartley
Could I use this to filter for the previous week with the week starting on Sunday? For tickets updated the previous week, Sun-Sat for a report that I would run each Monday morning. If so, how or is there an easier way to filter this specific way?
0
Brandon Tidd
Hi Jess Hartley Admin -
If you're just looking to Filter data based on the previous week, starting on Sunday - we can actually use the default "Ticket Created - Date" filter. In this case, we'd navigate over to "Advanced" and select "7 Days in the Past" to "2 Days in the Past." If run on Monday, this would give you Sun - Sat. If you ran it on Tuesday, you'd have to 'back date' it to 8 Days and 3 Days, respectively. Hope this helps!
Brandon Tidd
729 Solutions
0
Nicole
What may be the best way to have it run for monthly values, from the 1st of the month until the last day of the month (which varies)? Then the following Monday after the last day of the month it will be sent in a scheduled dashboard report.
0
Dane
There are two ways you can create this report. Please check the screenshot for reference. I have used the same attributes but placed it differently on rows, columns and filter sections.
The screenshot above shows all tickets created on the same days of the month.
On the other hand, this one will include all the days of the month and it will give you the ability to select specific days. You can modify it further depending on your preference.
Now, for Scheduling Dashboards Deliveries, it can be sent on a monthly basis. You can also select the numerical value of the day of the month.
0
Ravindra Singh
what if we want ticket created data weekly manner from Monday to Monday instead of Sunday to Saturday ?
0
Salim Cheurfi
It is possible to get tickets created from Monday to Monday, you can adapt the calculated attribute
LEFTPART(STARTOFWEEK_MONDAY([Ticket created - Date]),10)
You can as well change the overall setting of Explore to set a specific day as the start of the week, you'll find more information in our article : Setting the start of the week for reports and filters
I hope this helps,
Have a great day,
0
Mario Marge
Can you customize a report to use a Wednesday to Tuesday week?
This would be different than what is set within the Admin (Sun-Sat).
0
Brandon Tidd
Hey Mario -
Yep! Here are the instructions: https://support.zendesk.com/hc/en-us/articles/4418307079322-Setting-the-start-of-the-week-for-reports-and-filters
Brandon
0
Sneha Shaikh
Hello,
I need to create a report specifically for the weekend (Saturday and Sunday). I'm having difficulty retrieving the data to schedule a report for the last and previous weekends, focusing on tickets created and solved during the weekend. Currently, my explore is running based on a Sunday to Saturday week format. Any assistance with creating a calculated attribute to filter weekend data would be greatly appreciated.
Thank you.
0