bar chart y-axis

[#1]

Hi All,

I'm having a bar chart whose expression uses avg function. The values of this expression indicate percentage values as shown in screenshot 1.

I wanted to display % after every value so I tried concatenating % as follows avg()&'%' . This is displaying % after the expression value but Y-axis numbering is changed. As shown in Screenshot 2 Y-axis is having 0.20 when it has to display 20 and same is with other number. Is there any way to avoid this ?

Screenshot 1 :

  

Screenshot 2 :

Thank you!!!

[Gysbert_Wassenaar · Accepted solution]

Try dual(avg(MyField) & '%', avg(MyField))

[ashfaq_haseeb]

Hi,

Remove % and on expression click relative.

Regards

ASHFAQ

[#4]

Thank a lot