Explore recipe: Reporting on article views for all languages


What's my plan?





All Suites

Professional, Enterprise, or Enterprise Plus









Support with

Explore Professional or Enterprise






Contributed by community member CJ Johnson. For the original conversation, see Return Article Title in 1 language, roll up of all Language views?

In this recipe, you’ll learn how to create a report that shows you how many views each article in your knowledge base received, regardless of language, grouped under one title in your preferred language. This report is both streamlined (no duplicate rows for multiple languages) and human readable (no article IDs in place of reader-friendly article titles).

This article contains the following topics:

What you’ll need
Creating the report

What you’ll need
Skill level: Easy
Time required: 10 minutes

Zendesk Explore Professional or Enterprise
Editor or Admin permissions (see Giving agents access to Explore)
Article data in Zendesk Guide

Creating the report
As part of this report, you’ll create one standard calculated metric and two standard calculated attributes.
To create the metric

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.
Click the Calculations ( ) menu > Standard calculated metric.
Name this metric Views for all languages.
In the Formula field, enter the following:
ATTRIBUTE_FIX(SUM(Article views), [Article ID])

Tip: If you're working in a language other than English, read this article to help you enter Explore formulas in your language.

Click Save.


Tip: If you’re interested in learning more about the ATTRIBUTE_FIX function used in this metric, see Working with aggregation level functions.
To create the first attribute

Click the Calculations ( ) menu > Standard calculated attribute.
Name this attribute Location plus article ID.
In the Formula field, enter the following:
IF [Article ID] != "" THEN [Article ID] + [Article locale] ENDIF

Click Save.

Now that you’ve created this attribute, incorporate it into the next attribute to return only the English article title for a given article ID.
To create the second attribute

Click the Calculations ( ) menu and click Standard calculated attribute.
Name this attribute English article title (you can replace “English” with any other language you’re using).
In the Formula field, enter the following (if you're working in a different language, replace "en-us" with your own language code.):
IF (CONTAINS(LOWERCASE([Location plus article ID]),"en-us")) THEN [Article title] ENDIF

Click Save.

To create the report

In the Metrics panel, click Add and select Calculated metrics > Views for all languages (the metric you created above).
In the Rows panel, click Add and select Calculated attributes > English article title (the second attribute you created above).
Name your report Article views for all languages.
Click Save.
{
"@context": "https://schema.org",
"@type": "TechArticle",
"@id": "https://support.zendesk.com/hc/en-us/articles/4408835118106",
"url": "https://support.zendesk.com/hc/en-us/articles/4408835118106-Explore-recipe-Reporting-on-article-views-for-all-languages",
"headline": "Explore recipe: Reporting on article views for all languages",
"description": "You can create a report that aggregates article views across all languages under a single title in your preferred language by using calculated metrics and attributes in the reporting tool.",
"articleSection": "Help center reporting recipes",
"datePublished": "2021-10-16T04:00:16+00:00",
"dateModified": "2025-09-06T00:07:08+00:00",
"inLanguage": "en-US",
"mainEntityOfPage": {
"@type": "WebPage",
"@id": "https://support.zendesk.com/hc/en-us/articles/4408835118106"
},
"author": {
"@type": "Organization",
"name": "Zendesk",
"@id": "https://www.zendesk.com"
},
"publisher": {
"@type": "Organization",
"name": "Zendesk",
"@id": "https://www.zendesk.com"
},
"isPartOf": {
"@type": "WebSite",
"name": "Zendesk Help",
"@id": "https://support.zendesk.com/hc/"
},
"about": {
"@type": "SoftwareApplication",
"name": "Zendesk",
"@id": "https://www.zendesk.com",
"softwareAddOn": {
"@type": "SoftwareApplication",
"name": "Explore",
"@id": "https://support.zendesk.com/hc/en-us/sections/4405298856346"
}
}
}