This Explore query enables you to report on the number of tickets solved by articles linked to the ticket using the Knowledge Capture app.
What you'll need
Skill level: Easy
Time Required: 10 minutes
- Zendesk Explore Professional or Enterprise
- Editor or Admin permissions (see Adding users to Explore)
- Ticket data in Zendesk Support
- Zendesk Guide Professional, or Enterprise
- The Zendesk Knowledge Capture app must be installed. Additionally, the app must have collected some data by using it for a while. See Installing the Knowledge Capture app.
How to create the report in Explore
Use the following steps to create this report in Explore.
-
In Explore, click the query (
) icon.
- In the Queries library, click New query.
- On the Choose a dataset page, click Guide > Knowledge Capture > Guide: Knowledge Capture, then click New query. Query builder opens.
- In the Metrics panel, click Add.
- From the list of metrics, choose Knowledge Capture tickets > Resolution article tickets, then click Apply.
- In the Rows panel, click Add.
-
From the list of attributes, choose Time - Ticket solved > Ticket solved - Month, then click Apply.
The current query setup will match the following screenshot: -
By default, Explore chose a column chart to best display the data. To change this, click the Visualization type (
) icon.
- 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.
7 Comments
I wanted to try this query but when I choose to create a new query and then the Guide dataset type I can only create a new query for "Answer Bot". If I select "Knowledge Capture" I do not get the option to choose a dataset.
Hello Jay McCormack,
You might need to enable the app in the sidebar location since this is not going to be enabled by default. Once done, you should be able to create your desired query. Let us know if this solves your issue, and please reach out if you require further troubleshooting.
Best regards.
Hi Devan,
I'm not sure what you mean by enabling the app in the sidebar location.
Hey Jay McCormack -
Is the Knowledge Capture app enabled in your instance? I think Devan wanted to make sure you are utilizing the app first. You can check under Admin -> Manage:
and
And then enable the app here:
Hope that helps!
Confirming that is what Devan was asking. Thanks for jumping in, Melissa!
Hello Jay McCormack,
Yes, Melissa Norton is correct that I meant you needed to be utilizing the app first. :D
Sorry if I was unclear, this article should explain how to install the Knowlege Capture App.
Best regards.
Tried to do this report, and this is the result:
Please sign in to leave a comment.