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?
create a field YeaMonth, associate to your date field, and format it the way you want:
date(MonthStart(Date), 'MMM-YY') as YearMonth,
and use YearMonth as a dimension
You can use Monthname function as Monthanme(Date). It will five you yearmonth.
Retrieving data ...