Explore recipe: Creating weekly date buckets

What's my plan?

This recipe shows you how to display your weekly data in date buckets rather than just showing the individual week number.

What you'll need

Skill level: Medium

Time required: 20 mins

• Zendesk Explore Professional or Enterprise
• Editor or Admin permissions (see Giving agents access to Explore)
• Ticket data in Zendesk Support

Create your calculated attribute

To start, you will need to create a standard calculated attribute (see Creating standard calculated attributes).

To create your date buckets calculated attribute

1. In Zendesk Explore, click the reports () icon.
2. In the Reports library, click New report.
3. On the Select a dataset page, click Support > Support - Tickets, then click Start report. The report builder opens.
4. In your report, open the Calculations menu (), then click Standard calculated attribute. 
5. On the Standard calculated attribute page, under Name, enter a name for the attribute, like Week Bucket. You can change this name later if you want.  
6. In the Formula field, enter or paste the formula below:

   DATE_FORMAT(START_OF_WEEK_MONDAY([DATE(Date)]), 
   "YYYY-MM-dd") + " " + "to" + " " + 
   DATE_FORMAT(END_OF_WEEK_MONDAY([DATE(Date)]), "YYYY-MM-dd")

   Note: You need to update [DATE(Date)] to the name of the date attribute you would like to use like Ticket Solved - Date, Ticket First Assigned - Date, etc.

   For example, using Ticket Solved - Date, replace [DATE(Date)] with [Ticket Solved - Date].
   
   Tip: If you're working in a language other than English, read this article to help you enter Explore formulas in your language.
7. Click Save to create the calculated attribute. . 

Display your results

After you created your calculated attribute, you can add it and any other data to your report. When using the calculated attribute, rather than a pre-built week attribute, your results will display like the image below:

Alternatively, if you’re only interested in seeing the start of the week rather than the full duration, you can edit the formula and remove + " " + "to" + " " + DATE_FORMAT(END_OF_WEEK_MONDAY([DATE(Date)]), "YYYY-MM-dd").

The complete formula would look like below: 

DATE_FORMAT(START_OF_WEEK_MONDAY([DATE(Date)]), "YYYY-MM-dd")