Replace dimension values names in object properties

[#1]

I have one column named Company with all the values in the column equal to zero (no matter sens of that).

When I create a chart displaying sum of all records with Company = 0 (just one bar) the label of the bar is 0. I would like to change it to something else (e.g. 'zero') but from an object level (not script). Is there a way to do it?

[manas_bn]

Hello,

Instead of adding "Company" as a dimension, add a Calculated Dimension:

=if(Company='0','Zero',Company)

Change the label to Company

Hope this helps!

Manas

[gopalopsharma]

Hello,

We can change the Label of Any dimension or expression from the object properties. If you do not want anything then give a space.

This label is displayed below/ aside the Axes.

If my understanding is correct then the 0 which is appearing at the top of the Bar is the data value..

If you want to remove this then

• Go to object properties
• Go to Expressions tab
• Uncheck the "Values on data points" box present in the middle bottom
• Also since it is the value so it can not be changed

Please let me know if anything else is required.

[MayilVahanan]

HI

add a Calculated Dimension:

=if(Company='0','Zero',Company)

or in script

Load if(Company='0','Zero',Company) as Company from tablename;