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
- 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
- In Zendesk Explore, click the query () icon.
- In the Queries library, click New query.
- On the Choose a dataset page, click Support > Ticket updates > Support: Tickets, then click New query. Query builder opens.
- In your query, open the Calculations menu (), then click Standard calculated attribute.
- 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.
- In the Formula field, enter or paste the formula below:
"YYYY-MM-dd") + " " + "to" + " " +
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].
- 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 query. 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: