Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to add "%" sign to a number in expression?
here is my diagram:
Now, I would like to add "%" sign to every value, for example in diagram you can see "7.1". I would like it to be "7.1%"
Thanks!
In expressions, please untick value on data points.
Add same expression with &'%'
i.e. SUM(Sales) &' %'
Here untick bar and tick value on data points
In expressions, please untick value on data points.
Add same expression with &'%'
i.e. SUM(Sales) &' %'
Here untick bar and tick value on data points
Maybe divide your expressions by 100 and set number format in number tab to percentage?
Thanks! It is exactly what I wanted to do!
I have another question (not related to editing the chart).
here is the situation: I have two tables
Table A attributes: Age, "Total Population", "Mobile User (Unique User)"
Table B attributes: Sex, "Total Population", "Mobile User (Unique User)"
When I reload the script, my first chart (based on Table A) goes crazy.
What should I do in order to analyse the two tables separately?
Thanks!
Num(Sum(Sales ),'##,#0%') This is Num()
I do not understand
Could you elaborate on this please?
Sorry, I was thinking you are referring to my second question - the problem described in first question is solved.
May be because your both tables two fields are common and creating a synthetic key.
You should either try to rename the Population or Mobile User field or try
CAN HELP YOU better is I have your sample script.