This report provides a quick way to see the number of tickets in your account broken down by the assigned agent and the channel the ticket was submitted via. It uses one metric, and two attributes.
What you'll need
Skill level: Easy
Time required: 20 minutes
- Zendesk Explore Professional
- Editor or Admin permissions (see Giving agents access to Explore)
- Ticket and agent 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 query ( ) icon.
- In the Queries library, click New query.
- On the Choose a dataset page, click Support > Tickets > Support: Tickets, then click Apply. Query builder opens.
- Next, you need to add a metric. A metric is the thing you want to measure, in this case, the number of tickets. In the Metrics section, click Add.
- From the list of metrics, choose Tickets > Tickets, then click Apply. Notice that COUNT(Tickets) is displayed in the Metrics panel and Explore automatically displays the count of tickets in the main section of the page.
- Next, add the two attributes that will break down the number of tickets by assigned agent, and ticket channel. In the Columns section, click Add.
- From the list of attributes, choose Assignee > Assignee name, then click Apply.
- In the Rows section, click Add.
- From the list of attributes, choose Ticket > Ticket channel, then click Apply.
- You'll see something resembling the following chart:
Notice that by holding down CTRL (Windows), or OPTION (Mac) on your keyboard, you can select more than one ticket channel from the Ticket channel axis. Alternatively, click the header (in this case Ticket channel) to select all items.
By default, Explore chose a column chart to best display the data. However, the original Insights report displayed a bar graph. To change this, click the Visualization type () icon.
From the Visualization type menu, click Bar.
- Explore switches the chart to a bar graph. Assuming you select all ticket channels, you'll end up with something like the following:
- Now, you'll stack the results so that each agent name has only one bar showing the total number of tickets divided into colors for each channel type.
- Click the chart configuration () icon, then click Chart.
- On the Chart page, enable the Stacked setting.
- Click the chart configuration icon again to close the menu. Assuming all ticket channels are selected, you'll see something like the following:
- The query was, by default named New query. Click the New query text and replace it with a title of your own.
- Finally, click Save.