Page 1 of 1
Data transformation - Replacing values not showing up
Posted: Tue Mar 12, 2024 3:43 pm
by MKA
Dear
I have a dashboard with a table (see attachment 1).
- Attachment 1.png (60.33 KiB) Viewed 2105 times
Now I would likle to replace the category values with some other text. With other words replace in the table the values:
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 2105 times
What I am doing wrong?
Best regards
MKA
Re: Data transformation - Replacing values not showing up
Posted: Wed Mar 13, 2024 9:24 am
by Lech Kulikowski
Hello,
In this case, you should use the Calculate column in the original data source.
Thank you.
Re: Data transformation - Replacing values not showing up
Posted: Wed Mar 13, 2024 1:17 pm
by 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
Re: Data transformation - Replacing values not showing up
Posted: Thu Mar 14, 2024 11:52 am
by 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.