5

I would like the names of the columns in the table below to be different from the names of the columns in the database.
For example by changing "COD_STAT" to "Station ID".

change_table_column_names

How can this be done?

Alduin
  • 51
  • 1
  • 2

3 Answers3

7

You need to add VERBOSE NAME to your columns. You can perform it by following next steps:

  1. Explore your chart and choose tab EDIT DATASOURCE by clicking on your DATASOURCE button.
  2. In the lower left corner of opened window you can find button USE LEGACY DATASOURCE EDITOR. Click on it.
  3. In the EDIT TABLE window pick the tab COLUMNS. Now you can edit required columns and add VERBOSE NAME which will replace your db names after saving.

enter image description here

Miras
  • 106
  • 5
  • 1
    Would be nice to have this option on viz level so that the data source stays untouched – vlntn Apr 12 '23 at 05:28
5

Open your chart, then click the dots next to your datasource and pick "edit dataset"

enter image description here

Then click "Columns" and change the "Label" attribute:

enter image description here

Ben Wilson
  • 2,271
  • 3
  • 26
  • 35
  • 1
    If you need to do this for aggregates in metrics, click the arrow next to your field (in metrics) then click the pencil next to the field name and edit it. This is sometimes buggy and won't save or there is a lag on save occasionally. – Ben Wilson Jun 06 '22 at 03:07
3

Here are the steps:

  1. Click to Charts. enter image description here
  2. Goto Datasource dropdown and click on edit data source: enter image description here
  3. Select the dimension you want to modify by clicking the drop down: enter image description here
  4. You will find Label option and here you can enter your own title (For you, it's station ID). enter image description here
Shivam Sahil
  • 4,055
  • 3
  • 31
  • 62