More than a year at X-Axis

[#1]

Hello,

I have a table with dates and quantities for N years.

But i need to plot a chart, when on X-Axis is like:

jan-2010 | Feb-2010 | Mar-2010....... | Jan-2011| Feb-2011 | Mar-2011 and so on...

Can anyone help me?

Thank you

[Oleg_Troyansky · Accepted solution]

Yes,

create a field YeaMonth, associate to your date field, and format it the way you want:

load

     Date,

     date(MonthStart(Date), 'MMM-YY') as YearMonth,

     ...

and use YearMonth as a dimension

Oleg Troyansky

[vijay_iitkgp]

Hi ,

You can use Monthname function as Monthanme(Date). It will five you yearmonth.

Regards

VIjay