Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Translation of chart in report

martinkruml
Tera Guru

Hello,

 

I have a case, where I have translations setup, but the results in report still shows in english, even though my settings are in german. What I simply want to achieve is, if there is a way on how to translate chart titles in report view (image attached). 

Very satisfied = Sehr zufrieden for example

martinkruml_0-1739881919814.png

 

5 REPLIES 5

Alex Coope - SN
ServiceNow Employee
ServiceNow Employee

Hi @martinkruml,

What table is your report configured to, and what field type is the columns shown based on (the field of the satisfactions)?


Many thanks,
Kind regards 

--------------------------------------------------------------------
Director of Globalization Deployment, Internationalization

Hi @Alex Coope - SN 

My report is configured to asmt_metric_result, columns are based on asmt_metric_definition. 

Since user's answers are based on wording values, I feel like metric is seeing it as numbers 1-5 which are linked to the template (i used the ootb smiley faces one).

 

martinkruml_1-1739882809353.png

 

Ok, so two things come to mind,

If the assessment / survey wasn't translated, you can follow the instructions here, if you have pre-translated everything as per the linked blog post, try doing a "cache.do" to ensure your browser has picked up all of the translations and to ensure you don't have a browser cache'ing issue.

If it's the smiley faces question type (image scale), then yes server-side it would be storing as numbers which would mean the labels are not necessarily translated (the "display_label" field should be of type "translated_text", meaning the translations would reside in [sys_translated_text]),

For sure worth going through my linked blog post to ensure the translations are present,

Many thanks,
kind regards



--------------------------------------------------------------------
Director of Globalization Deployment, Internationalization

I have tried according to guide with my colleague setup this and it still seems not working. 

So far, only workaround I could make work, was edit survey definitions and type both english and german naming.

We tried both sys_translated_text and also sys_translated.

Any other ideas?