Year Month on X axis

Mon, 29 Feb 2016 07:04:36 GMT

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

Re: Year Month on X axis

kaushiknsolanki — Mon, 29 Feb 2016 19:05:26 GMT

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

topic Re: Year Month on X axis in App Development

Year Month on X axis

Re: Year Month on X axis