这道菜了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 (seeGiving agents access to Explore)
- Ticket data in Zendesk Support
Create your calculated attribute
To start, you will need to create a standard calculated attribute (seeCreating standard calculated attributes).
To create your date buckets calculatedattribute
- In Zendesk Explore, click the reports () icon.
- In the Reports library, click新报告。
- On theSelect a datasetpage, click支持>支持- Tickets,然后单击Start report. The report builder opens.
- In your report, open theCalculationsmenu(), then clickStandard calculated attribute.
- On theStandard calculated attributepage, underName, enter a name for the attribute, likeWeek Bucket. You can change this name later if you want.
- In theFormulafield, 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 likeTicket Solved - Date,Ticket First Assigned - Date, etc.
For example, usingTicket Solved - Date, replace[DATE(Date)]with[Ticket Solved - Date].
Tip:If you're working in a language other than English,read this articleto help you enter Explore formulas in your language. - ClickSaveto 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")
8 Comments
Is this possible for two weeks?
like from 29 November to 5th December and from 6th December to 12th December on the report ?
If you only want to see certain weekly date buckets (in your case, for two weeks only) in your query, you can click into the weekly date bucket attribute that you just created and filter out the two weeks like in the screenshot below:
Once you applied the filter into the attribute, you should only see the two weeks bucket in your query instead of seeing a long list of weekly buckets.
Hope this helps! Stay safe!
Hi. Please support how to select "Tickets created" in metrics when there is no such option. I need you assistance. Thank you
Are you trying to create a query and the metrics is not showing even after searching for the same in Metrics?
Hi Taguhi,
I found the metric "Tickets created" in another dataset, Support - Updates. Not Support - Tickets as shown in the recipe above.
Olá,
No meu caso a personalização das semanas para os dias da semana deu certo porém, a ordem cronológica veio ordenada pelas primeiras semanas do ano.Alguém saberia me dizer o porque ou como eu poderia reclassificar essa ordem sem ser manualmente?
A ordem ficou assim:
Usei a mesma fórmula dada anteriormente:
Espero que esteja tudo bem! Você pode tentar organizar os valores através das ferramentas deOrganização de valores por grupos e conjuntos.
Espero que isso ajude!
Is it possible to aggregate the EOY duplicate weeks? Or some workaround to resolve this?
Pleasesign into leave a comment.