Add field to the x-axis in the chart only for display

[udaya_kumar]

Hi,

I have a chart which contains city name in x-axis like Bangalore, Hyderabad, Chennai,....

But i need to show it as Bangalore-Karnataka, Hyderabad-AP,Chennai-TamilNadu.

like this in the chart only for display in the x-axis.

how can we do this?

[#2]

Could You be more specific? or post some snapshot?

[udaya_kumar]

Hi pari,

I dont want the x-axis label to look like in the image Not_Like_This.png.

I want the x-axis label to look like in the image Like_This.png.

Bangalore and hyderabad values comes from the field City

and the Karnataka and AP values comes from the field State.

so how to combine it in the x-axis label.

and i am using Valuelist in the dimension, to select particular dimension based on some condition.

[#4]

where'd You get Karnataka, AP from?

[udaya_kumar]

From the database field State.

[Anonymous]

Try in the chart dimension, City & ' ' & State.

Regards.

[SunilChauhan]

use below

City & '- ' & State as YourFieldname

in Script

and take YourFieldname in your dimension

Hope this helps