Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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