nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Custom Naming with "Chart From Table" Macro

William Haase_dyf8hz

I am looking for a solution to fix the automatic naming when creating multiple charts with the Chart from Table macro. Due to the nature of the data table(Confiform Tableview-->Pivot Table) in the marco fields the "label" column and "value" column are both using the same variable name so the automatic name is output as "Variable1-Variable1" ,"Variable2-Variable2", and so on for all the charts. Is there any solution to fix this?

Accepted answers

Stiltsoft support

Hi @William Haase ,

You may place the Table Transformer macro between the Confiform Tableview and Pivot Table or Pivot Table and Chart from Table (as is more convenient for you) and rename the columns:

SELECT

T1.'Column 1' AS 'New Name for Column 1',

T1.'Column 2' AS 'New Name for Column 2',

T1.'Column 3' AS 'New Name for Column 3'

FROM T1

After the Table Transformer macro your table will have hew headers that will be used by the macros that are placed on top of this Table Transformer macro.

All comments

Stiltsoft support

Hi @William Haase ,

You may place the Table Transformer macro between the Confiform Tableview and Pivot Table or Pivot Table and Chart from Table (as is more convenient for you) and rename the columns:

SELECT

T1.'Column 1' AS 'New Name for Column 1',

T1.'Column 2' AS 'New Name for Column 2',

T1.'Column 3' AS 'New Name for Column 3'

FROM T1

After the Table Transformer macro your table will have hew headers that will be used by the macros that are placed on top of this Table Transformer macro.

William Haase_dyf8hz

Hey @Stiltsoft support thanks for the response. I wanted to expand on the issue I'm seeing further. Attached is an example of the Result from the Macro. Due to the nature of the confiform configuration this is the way the labels and values need to be set up. I am looking to only show 'Column 1" once for related chart not twice

Confiforms Chart from Table Macro.PNG

Stiltsoft support

Hi @William Haase ,

Not sure that we got the issue - maybe the source table (or manually created table with dummy data that has the same structure as your source table coming from the Confiforms) may help? Or maybe even not the Confiforms but what you get after the Pivot Table macro (what table you use to create your charts)?

If the question is how to build three separate charts based on the same table, you may reuse your source table several times with the help of the Table Excerpt/Table Excerpt Include macros, wrap each Include in the Chart from Table macro and create independent charts.