Insights recipe: Solved tickets by agent

Zendesk Explore, our new analytics software, is replacing Insights. Most customers who purchased Zendesk Support after July 2018, or have been migrated to Explore don’t have access to Insights. You can find Explore in the Zendesk product tray.

This report enables you to evaluate agent performance by viewing the number of solved tickets. There are two ways you can view the number of solved tickets by agent. You can either use Insights' default View Only dashboard or create a custom report. This recipe will cover both options. 

Skill level: Easy

Time required: 10 minutes

Ingredients:

• Option 1: View Only dashboard
• Option 2: One built-in metric, two attributes. 

Option 1: View Only dashboard

Insights' default View Only dashboard contains an agent activity report that analyzes the number of solved tickets per agent by day. The agent activity report is located under the headline metrics in the agent activity tab.

You can drill-in to view individual ticket details by selecting any point on the report. You can also specify a Date Range on the dashboard with the use of disconnected date dimensions. For more information on disconnected date dimensions see, Understanding disconnected date dimensions in Insights (Professional and Enterprise).

Option 2: Custom report

When creating your own report, you cannot directly copy the metric used in the agent activity report in the View Only dashboard. To make a new report to track the number of solved tickets by agents, you will need to select new metrics and attributes.

Keep in mind this is only one way to display # Solved Tickets. There are many different options to analyze daily productivity. 

Creating your report

1. Click the Reporting icon () on the sidebar in the agent interface, then click the Insights tab.
2. Click the GoodData link in the top right corner. 
3. In GoodData, click Report>Create Report.
4. Under the What panel, select the built-in metric # Solved Tickets.

   

5. Under the How panel select Ticket Assignee and Week(Mon-Sun/Year(Ticket Solved).

   

6. Click Done.

Customizing your report

You can use the List of Values filter to restrict the date range or filter out assignees. For this report, we zoom in on last week's ticket solves and filter out the (empty value) under the assignee. 

Note: If you publish this report to a dashboard, you can only view the week selected when you created your report. To edit the date range on the dashboard, you must use disconnected date dimensions. For more information on disconnected date dimensions see, Understanding disconnected date dimensions in Insights (Professional and Enterprise). For a list of disconnected date dimension metrics, see Insights metrics reference (Professional and Enterprise). 

1. In the List of Values filter select, Week (Mon-Sun)/Year(Ticket Solved) is last week.
2. Click Apply.
3. In the List of Values filter select, Ticket Assignee isn't (empty value).
4. Click Apply.

   

5. Select the Bar Chart from chart types. 

   

6. Click the Show Configurations link next to chart types. 
7. Under Global Settings, uncheck Gridlines and Data Labels.
8. Click Apply.

   

9. Click Create.

Your report will resemble the image below. 

Configuring dashboard drill-in

You can apply drill-in settings to view more detailed information about your reports. This recipe drill-ins to the ticket solved date, but you can select other attributes in your own report.

1. On your Dashboard tab, click the gear icon (), then select Edit.
2. Click Reports, then double click your report title to publish to the dashboard. 
3. Click the report, then click the gear icon next to the report. 
4. Select Add Drilling.

   

5. Select # Solved Tickets from the Select Metric/Attribute drop-down list.

   

6. Select your drill-in attribute. If you are using a date attribute, you need to check Show date attributes at the bottom of the menu. 

   

7. Click Select.
8. To view your drill-in options, click a bar on your report. You can change the style of the drill-in report by clicking the chart type icons in the upper-right hand corner.