Copy/Paste Tooltip Text, Translation within Dundas

Hi,

We’re building a dashboard that contains text in a table that users would like to copy/paste and then analyze.

Ideally, we’d like to be able to automatically translate the text within Dundas, if it is another language besides English, but if that isn’t possible, then ideally the tooltip should be copy/pasteable.

Is there a way to do these 2 items with a custom script, or by hooking up to an API translation tool within Dundas?

Thanks,
Mario

1 Like

You would need to retrieve the culture at the data cube level and modify the text there, as the it is too late at the dashboard level to change text like you would want to. You can do this via a calculated element.

https://www.dundas.com/Support/learning/documentation/cleanse-consolidate-modify-data/transforms/common/calculated-element

Fortunately, you can do this by using the CultureInfo.InstalledUICulture object to retrieve the user system’s culture setting.

Then you can use a series of if statements to go through the values you would like to check for, and then return the appropriate translation at that point (you will need to provide the translations manually).

I think adding the translations manually at this point in time would take too long… at the metric set/dashboard level, is there a way I’d be able to copy and paste the information/strings from a table on the tooltip hover?

Any update or potential solution to this?

@mario.nicastro
Where is the translation coming from that you are wanting to put in the tooltip?

Ideally Google Translate, or some other type of translation API that can easily connect to Dundas and do the translations automatically.

I think your best bet here is to let your users export the table to excel and then they can easily copy the non English string into what every translation program they want.