Explore recipe: Counting the agents who use the knowledge section

What's my plan?

In this Explore recipe, you'll learn how to calculate the number of agents who are using the knowledge section of the context panel.

With this report, you can extrapolate whether your agents are becoming more aware of your help center resources. If you have an implementation of KCS (Knowledge-Centered Service), this is a good way to understand how participation in the program is evolving.

This article contains the following topics:

• What you’ll need
• Creating the report

What you’ll need

Skill level: Intermediate

Time required: 10 minutes

• Zendesk Explore Professional or Enterprise
• Editor or Admin permissions (see Giving agents access to Explore)

Creating the report

For this recipe, you'll create a standard calculated metric in the Knowledge Capture dataset to have a count of users who link, flag, or create articles.

1. In Explore, click the reports () icon.
2. In the Reports library, click New report.
3. On the Select a dataset page, click Guide > Guide - Knowledge Capture, then click Start report. The report builder opens.
4. Go to the Calculations () menu and select Standard calculated metric.
5. Name the metric Users.
6. In the Formula field, enter the following:

   DCOUNT_VALUES([User ID])

   
   
   Tip: If you're working in a language other than English, read this article to help you enter Explore formulas in your language.
7. Click Save.
8. In the Metrics panel, click Add.
9. From the list, select Calculated metrics > Users and then click Apply.
10. Under Metrics, click SUM(Users) and change the metric to D_Count. Click Apply.
11. In the Filters panel, click Add.
12. Select Knowledge Capture and then click Knowledge Capture type.
13. Click the filter Knowledge Capture type and select Created, Flagged, and Linked. Then, click Apply.
    

Customizing your report

If you want to add a timeline to your report and see how the number of agents participating changes according to time, add a time attribute to the report. In the example below, the timeline shows an overview per month.

1. In the Columns panel, select Add.
2. Click Time - Knowledge capture event and select Event - Year and Event - Month. Click Apply.
3. Click the visualization type icon (). Select Line.

For more information, see Customizing reports.