This Explore recipe shows you how to create a report that lists the calls received per date, hour, and half-hour segments of when it was created. To be able to display half-hour segments, you need to create astandard calculated attribute.
What you'll need
Skill level: Average
所需时间:10 mins
- Zendesk Explore Professional or Enterprise
- Editor or Admin permissions (seeAdding users to Explore)
- Ticket data in Zendesk Support
How to create the report in Explore
Use the following steps to create this report in Explore.
- In Zendesk Explore, click the reports (
) icon. - In the Reports library, clickNew report.
- On theSelect a datasetpage, clickTalk>Talk - Callsdataset, then clickStart report. The report builder opens.
- In theMetricspanel, clickAdd.
- From the list of metrics, chooseCalls>Calls,然后单击Apply.
- In theRowspanel, clickAdd.
- From the list of attributes, choose时间,电话开始>Call - Dateand时间,电话开始>Call - Hour,然后单击Apply.
- In the calculations menu (
), clickStandard calculated attribute. TheStandard calculated attributepage opens. - In theNamefield, type a name for your new metric, for example,Call - Half hour.
- In theFormulafield, enter or paste the following formula, then clickSave.
Tip:If you're working in a language other than English,read this articleto help you enter Explore formulas in your language.IF ([Call - Minute]<=30) THEN "0-30"
ELIF ([Call - Minute]>30 AND [Call - Minute]<=60) THEN "30-60"
ENDIF
You can now add this calculated attribute to the report above or use it in your own reports, for example:
2 Comments
The only selection that is listed under Time - Call started is Call - Timestamp
Am I looking in the wrong place?
Hello Lynn,
That's odd if you're only showing that option. Can you make sure that there aren't any texts in the search box that could limit the relevant attributes listed?
Pleasesign into leave a comment.