Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi ,
You can use Monthname function as Monthanme(Date). It will five you yearmonth.
Regards
VIjay