In this Explore recipe, you’ll learn how to report on the total number of views a category in your knowledge base has received, across all articles in that category.
While Explore doesn't include a default attribute for help center category, you can create a group attribute that groups articles by the categories they belong to.
This article contains the following topics:
What you'll need
Skill level: Intermediate
Time required: 10 minutes
- Zendesk Explore Professional or Enterprise
- Editor or Admin permissions (see Giving users access to Explore)
- Article data in Zendesk Guide
Creating the group attribute
- In Explore, click the reports () icon.
- In the Reports library, click New report.
- On the Select a dataset page, click Guide > Guide - Knowledge Base, then click Start report. The report builder opens.
- In the Calculations menu (), select Group.
- In the Attribute name field, name your calculated attribute Articles by category.
- In the Computed from field, select Article title.
- In the left column under the Search box, select an article and click the plus (+) icon to create your first category. Add more articles to that same category by selecting their titles in the left column and clicking the right arrow (→) icon.
- Rename your category by clicking the line in the right column that starts with "Group [title of the first article you added to the category]" and entering your desired category name.
- Repeat the previous two steps to create more categories. For help, see Creating groups.
- Click Save.
Creating the report
- In the Metrics panel, click Add > Knowledge base engagement > Article views.
- Click Apply.
- Change the metric aggregator to SUM.
- In the Rows panel, click Add > Calculated attributes > Articles by category.
- Click Apply.
The resulting report is a table that lists the categories in your help center and how many views each category has.
Enhancing the report
If you want, you can take a few extra steps to list the specific articles that belong to each category, with a subtotal row that still shows the total number of views for each category.
- In the Rows panel, click Add > Articles > Article title.
- (Optional) Filter out the NULL value by clicking the Article title attribute you just added, selecting the Excluded tab, and selecting NULL > Apply. (The NULL value comes from articles that previously had views but have since been deleted.)
- In the Result manipulation () menu, click Totals, select Subtotals on Rows, and click Apply.
Your report now shows which articles are included in each category, with a Sum line that still shows the total views for that category.
Additionally, you might have noticed that the total number of views for the Testing category in the screenshot above is different than in the previous section's screenshot. This is because we filtered out the NULL value.
5 comments
Ryan Boyer
Thanks for outlining this query. If I'm reading this correctly, for a category that has 500 articles, we would have to manually place each article title one by one in each category in the attribute?
0
Gab Guinto
That is right, I'm afraid there is no other workaround at the moment. You will need to manually group the articles when building the custom attribute.
0
Samm F
Ryan Boyer - I haven't tested this personally but I believe you could achieve the same while using Section Title for grouping rather than the article title.
You would just have to click 'Calculations' and change your "Computed from" to Section Title.
(You can then match these groups to your Guide Categories fairly simply)
1
Scott Wallace
Unfortunately, the attribute isn't working for me as I'm getting every single article title from the knowledge base appear as opposed to the handful I've selected for my grouping (the grouping doesn't show at all).
Has anyone else run into this issue?
0
Suelem Oliveira
I have replied to your Support ticket about this. Let's keep the conversation in the ticket so I can help you further with the report!
0