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?