Define the size and rename the columns in pivot or evolution grids with VEEML

Question

I wanted to change the size of a column in the pivot grid but didn't work. Could you explain how does it work?

Answer 1

You can specify the size and rename each columns using the chart options:

The syntaxe is like below :

{"columns":[{"width":100,"name":"REGION","label":"Area"},{"width":80,"name":"Quantity","label":"Qty"},{"width":100,"name":"Ratio","label":"Year on Year"}]}

Here we rename the dimension REGION to Area, the metric Quantity to Qty.

The label of the "Evolution" column is by default "Evo" and its name is Ratio.

Here we renamed it to Year on Year.