Data transformation - Replacing values not showing up

[MKA]

Dear

I have a dashboard with a table (see attachment 1).

Attachment 1.png (60.33 KiB) Viewed 2103 times

Now I would likle to replace the category values with some other text. With other words replace in the table the values:

• 1 by 'Category 1'

• 2 by 'Category 2'

• 3 by 'Category 3'

• ...

But, if I open the header menu in data transformations, the 'replacing values' menu item is missing under actions (see attachment 2).

Attachment 2.png (34.27 KiB) Viewed 2103 times

What I am doing wrong?

Best regards
MKA

[Lech Kulikowski]

Hello,

In this case, you should use the Calculate column in the original data source.

Thank you.

[MKA]

Dear Lech

Thank you very much for your reply.

"Category 1", "Category 2", ... were just an example. This table represents the number and percentage of types of incidents. So, the category id's I would like to replace by:

• 1 should become "Fire incidents"

• 2 should become "Hazard incidents"

• 3 should become "Road accidents"

• ...

Furthermore, it should also be possible to show that report in different languages. (localize these strings)

Best regards
MKA

[Lech Kulikowski]

Hello,

> "Category 1", "Category 2", ... were just an example. This table represents the number and percentage of types of incidents. So, the category id's I would like to replace by:

It can be made in the original data source or calculated columns, there are no other options.

> Furthermore, it should also be possible to show that report in different languages. (localize these strings)

Please check the Globalization Strings option of the report:
https://www.stimulsoft.com/en/documenta ... editor.htm

Thank you.