Explore recipe: Reporting on article views for all languages

What's my plan?

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

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 Base, then click Start report. The report builder opens.
4. Click the Calculations () menu > Standard calculated metric.
5. Name this metric Views for all languages.
6. 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.
7. 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

1. Click the Calculations () menu > Standard calculated attribute.
2. Name this attribute Location plus article ID.
3. In the Formula field, enter the following:

   IF [Article ID] != "" THEN
   [Article ID] + [Article locale]
   ENDIF

4. 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

1. Click the Calculations () menu and click Standard calculated attribute.
2. Name this attribute English article title (you can replace “English” with any other language you’re using).
3. 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

4. Click Save.

To create the report

1. In the Metrics panel, click Add and select Calculated metrics > Views for all languages (the metric you created above).
2. In the Rows panel, click Add and select Calculated attributes > English article title (the second attribute you created above).
3. Name your report Article views for all languages.
4. Click Save.