Year Month on X axis

[#1]

I have 2 fields , one is a year field ( with values 1 and 2 ) , the other is a month field ( values 1 - 12) . These are both dimensions I add onto a bar chart , with the measure being a count of some field. When I drag the month field on as the first dimension , and the year field on as the second dimension, it plots 2 lines , each representing a year ... how can I control this to plot both dimensions on the X axis , for a 24 month time plot....is the only way to do this is to have a date field?

Thanks

G

[kaushiknsolanki]

Hi,

You can create one more field as Year Month in script. and then you can use that in dimension.

Load *,Year&'-'&Month as YearMonth

From xyz;

Regards,

Kaushik Solanki