Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Please let me know if anything else is required.
HI
add a Calculated Dimension:
=if(Company='0','Zero',Company)
or in script
Load if(Company='0','Zero',Company) as Company from tablename;