Explore recipe: Using a Sunday to Saturday week attribute

In this Explore recipe, you'll learn how to create a Standard calculated attribute that reports on data by week with Sunday as the start of the week. The built-in Week of year attributes will show weeks based on a start date of Monday with the end date of Sunday.

What you'll need

Skill level: Moderate

Time Required: 10 minutes

• Zendesk Explore Professional
• Editor or Admin permissions (see Adding users to Explore)
• Ticket data in Zendesk Support

Creating the attribute

1. In Zendesk Explore, click the query () icon.
2. In the Queries Library, click New Query.
3. Now, select the dataset you would like to create queries with the custom attribute. In the example below, use Support: Tickets.
4. Click Calculations (), and then click Standard calculated attribute.
5. Copy the formula below and paste it into the attribute editor.

   LEFTPART(START_OF_WEEK_SUNDAY([Ticket created - Date]),10) 

   
6. Give the attribute a name like Ticket created - Sunday-Saturday.
7. 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, you would need to edit the attribute above and replace [Ticket created - Date] with [Ticket solved - Date].

You can now use this attribute in your queries. 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).