The Possibilities with Multilingual Dashboards in Tableau CRM

This post originally appeared on the Atrium blog. Authored by SAHIL JAIN.

Have you ever thought about a dashboard that is viewable in multiple languages depending on user location or language preferences, but wondered if it’s even possible? Well, the answer is yes, and it can be done in a few easy steps. Let’s first identify the use case where having a dashboard in multiple languages becomes the necessity.

Use Case for Multilingual Dashboards

Steps to Set Up Multilingual Dashboard

Step 1: Create a Custom Metadata Type in Salesforce for Each Dashboard

Type Custom in Quick Find Box→

Select Custom Metadata type.

Then create new a Custom Metadata type with the following label and api name as given:

For each label in a dashboard, create a custom picklist field in the Custom Metadata type. For instance, let’s say the demo dashboard looks like this:

We can clearly see that there are three labels in the dashboard, so the in the next step, we will create three picklist fields in the DemoData Custom Metadata type as follows:

Then, create a single record for DemoData by selecting values for custom field as given below:

Step 2: Adding Translation Using Translation Workbench

For each language that the dashboard should support, a translation would be added. This is when the translation workbench is used. Remember, the translation workbench does not translate the labels — it only stores the translation for labels that we add into it.

  • To do so, go to setup → translation workbench → translate.
  • Select the language for which the translations will be added, then the object (Custom Metadata) that was created. In the setup component, opt for Picklist Value.
  • In the lower panel, add translation for all the picklist fields, and click save.

*Note: By doing this, we have created a separate translation list for a particular language.

This will be used in the dashboard using the tolabel() function in SOQL query.tolabel() to convert the fields into the user’s language if the translation workbench is enabled. The SOQL, along with tolabel(), displays the labels in a language based on the currently selected user locale field.

Step 3: Adding SOQL Query for DemoData to the Dashboard

Step 4: Adding Result Binding to the Text Labels in the Dashboard

Final Results

To test this, change the default locale of the user to French, and see the magic for yourself!

After updating the user language to French, the language of dashboard labels have automatically changed to French. Voila!

Learn more about Atrium’s analytics expertise and services.

As the market leader in intelligent solutions, we help organizations make smarter decisions and act on them. Learn more at atrium.ai

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store