Zendesk uses web cookies to collect information about you when you visit our Site. This information might be about you, your preferences, or your device. At Zendesk, we may use this information for purposes that include ensuring basic functionality of our Sites; remembering user preferences, including your cookie preferences; measuring the effectiveness of our Sites, marketing campaigns, and email communications; and personalizing online content.
Please review the different category headings below to learn more and adjust the cookie settings on your current device. Please note that you will need to ensure that each web browser is adjusted to reflect your preferences if you use different computers or mobile devices.
For more information about how Zendesk uses web cookies, please see our Cookie Notice.
80 comments
Erin O'Callaghan
We've added 17 new Explore recipes that help you report on many different aspects of your Zendesk Sell data:
0
Erin O'Callaghan
We've added four new Explore recipes that help you take advantage of the new Calls dataset for Zendesk Sell:
1
Erin O'Callaghan
We've added a couple new Explore recipes for you:
0
Ilaria
Hi! We mainly rely on tags for our queries, and I wanted to ask whether there's a way to report about the number of tickets containing a certain tag vs. the total number of tickets for that day or month. Thanks!
0
Erin O'Callaghan
Hi Ilaria, you should be able to do this by following these steps:
Optionally, you can also follow these instructions to add a separate column to show the absolute value of tickets in addition to the percentage of the total.
0
Ilaria
Erin O'Callaghan thank you for this. However, with this, I can see the percentage of tickets tagged "Blue" vs. "Other tags". Is there instead a way to see the tickets tagged "Blue" vs. the number of tickets created? Basically I want to be able to see, for instance, that "On May 16th we received 100 tickets and of these, 80 were tagged blue". Thanks!
0
Erin O'Callaghan
Ilaria Yep, there is! In that case, you can skip the result path calculation and just add a total on rows instead. In the example report below, you can see that there were 4 tickets tagged with "Blue" out of 24 tickets created total.
0
Yasmin De Souza (she/ela)
1
Alex Zheng
I would start with something like using the % Breached tickets metric and the assignee name attribute in the SLA dataset and you can build on from there.
Let me know if you have any further questions.
1
Erin O'Callaghan
We've added a new Explore recipe that helps you keep tabs on the number of tickets your organization has in each status:
0
Elliott Johnson
Looking at these formulas for ZD Guide I'm wondering - is there a way to report on article views by organization/user email? Looking through the available data points in the stock Explore Knowledge queries, it doesn't appear so.
0
Brett Bowser
AFAIK this isn't possible with Explore at this time. That being said, you may be able to accomplish this using Google Analytics to track this information. I'd recommend starting with this article for more information: Google Analytics and your help center - Part 1: Asking the right questions
I hope this helps!
0
Elizabeth Churchill
I would like to know how many tickets were created on weekdays (M-F) and weekends (S-S) but I would like the data split between the day shift and the evening shift. I have created a report that shows weekday and weekend tickets for 2021 and 2022 but how do I overlay the daily shifts. When I apply the group for shifts I get an error. How do i further break down the weekend and weekdays by shifts?
0
Dave Dyson
0
Erin O'Callaghan
We've added a new recipe for Sell that helps you analyze deal progression through the sales pipeline:
0
GS Admin
Hi team ,
I am looking to create a report for tickets sent from L1 group to L2 group .
So i want to create a table which has the total number of tickets assigned to each agent and out of that how many were transferred to L2 team for further investigation.
we have a few unique identifiers like when a L1 agent sends tickets to L2 , a tag gets added to the ticket and there is a check box which is checked and also there a drop down filed in which the agent will update his name so that we know that the ticket was sent to L2 by him.
I have tried to create a report with the tickets assigned per agent.But i am unable to add the column where the count of transferred tickets will be displayed .
Could anyone please help me , as i have tried a lot of things and still i am unable to figure out a way for creating the above report which is one of our KPI's we need to track.
0
Dainne Kiara Lucena-Laxamana
Hi GS Admin
I recommend trying out this Explore recipe (Explore recipe: Tracking ticket assigns across groups ) which would show the number of times tickets were assigned from one group to another. Since this is just a recipe, you can customize it as you see fit. You can use this as a guide to creating your ideal report. Hope this helps!
0
GS Admin
Dainne Kiara Lucena-Laxamana
thanks for your response.
I have created created a calculated metric for ticket assigned from one group to another , but i am not sure how i can get the details on how to break down this count to get how many tickets were sent by a particular agent.
If i give assignee name in rows i get the current assignee , but i need count of how many tickets were send from one group to other group by each support agent.
What we are trying to find out is out of the total tickets assigned to L1 agents monthly how many of these tickets are being sent to L2 for further investigation.
I have report for tickets assigned to agent and another report for tickets sent to L2 we have 2 different reports as we are using different attributes . i want to see if there is a way where i could display both the values in same report and then calculate the percentage.
0
Dainne Kiara Lucena-Laxamana
Hi GS Admin
You'd need to use the dataset "Updates History" instead of the "Support: Ticket" dataset since you are tracking the updates on the tickets. The "Support: Ticket" dataset won't be able to show you the updates, only the current status of the ticket. More information about datasets here.
Once you use the dataset "Updates History", you can then add the attribute "Updater Name" under "Rows" so it would break down the updates from L1/L2. I would also recommend checking out the article metrics and attributes for Zendesk Support.
0
Erin O'Callaghan
We've added a new recipe for Support that shows you how to create alternate SLA metrics that use duration instead of status to determine when SLAs are achieved or breached:
0
Johny Einarsson
Hi,
I'm trying to figure out how to make reports (such as % satisfaction, good and bad satisfaction per agent) based on the last 100 rated tickets. I just cannot figure it out. I've tried making top/bottom attributes, metrics based on those attributes, all kinds of stuff. I'd think it would be a stock thing to filter based on the last x amount of ticket IDs but I guess not. Please advise before my head explodes.
0
Gab Guinto
You can try a workaround involving a custom metric to convert the Ticket ID to a numeric value. Example:
You can then add this metric to your table and use it to filter your results.
This Top/bottom filter should give you the top 100 values from the custom metric which should correspond to the 100 most recent tickets submitted to your Zendesk. Since the custom metric is only for sorting/filtering your results, you can hide the metric column from the table. Note that this will only work if your table is sliced by Ticket ID.
Hope this helps. Thanks Johny!
0
Johny Einarsson
Hi Gab,
That's an intriguing idea but I've tried it now and the SQL query is being strangled because it's over 50 000 rows.
0
Gab Guinto
I see. Yes, adding calculated metrics will add more rows to the underlying calculation. This may be more ideal when working with a relatively smaller set of data. If you plan on exploring more into this workaround, then you may have to filter down your report further or slice the data into separate tables/reports.
0
Erin O'Callaghan
We've added a new recipe for Guide that lets you report on the number of article views for help center categories (using a calculated attribute):
0
Karen C. Early
Thanks for you work!
1
Erin O'Callaghan
We've added a new Explore recipe that shows you how to report on messaging tickets by channel:
0
Benjamin Železnik
Hi all,
This sounds pretty basic, but I cannot find a way:
I'd like to have days on the x axis, and sum of tickets by status on y axis. Filtered by dates and ticket organization. Something like on the attached image. Asking for Zendesk Support.
Is this possible?
Regards,
Benjamin
0
Paul K
Benjamin Železnik yeah that's possible.
Use the Support: Backlog history [default] dataset to create your report.
Metrics: SUM(Tickets)
Columns: Backlog recorded - Date
Rows: Status
It should default to a line chart but, if not, click Visualization Type in the sidebar on the right and change it to Line.
If you need to rotate the dates in the X axis, like in your screenshot, select Chart configuration in the sidebar on the right > X axis > Change Label rotation to 45.
To put the status legend at the bottom of the screen, like your screenshot, go to Chart configuration > Legend > Change Legend position to Bottom.
0
Benjamin Železnik
Hi Paul K,
Thanks for your swift answer, it was of great help. What I missed most was the "Rows: Status" part.
However, I cannot find the way to filter by ticket organization. Maybe you have another hint for me?
0