Menelaos Kotoglou
05/23/2023, 3:40 PMCrude oil tanker
instead of CRUDE_OIL_TANKER
etc?Joseph Heun
05/23/2023, 3:42 PMMenelaos Kotoglou
05/23/2023, 3:50 PMJoseph Heun
05/23/2023, 3:52 PMMenelaos Kotoglou
05/23/2023, 3:53 PMMenelaos Kotoglou
05/23/2023, 4:00 PMTomas Muchka
05/23/2023, 7:23 PMCRUDE_OIL_TANKER
. The values can be beautified in two ways:
• Update the values in your DB. If the values should keep the original form, but you are fine to add a new column with “human-readable” names, then you can map the new column to the original attribute as a label. This way GoodData still displays one field, but you can switch between multiple display forms (labels).
• Or create a custom SQL dataset with the transformation logic. A combination of SQL REPLACE and LOWER functions would lead to crude oil tanker
.