As i can see now it is quite opposite. Current version shows all months, and the requirement is to show only hte 1st month of the quarter - but the data points must be for all months.
See what I tried - and got some result.
First step is to create an artificial dimension that has "normal" value for the 1st months of the quarter, and value that contains blanks, and character chr(10) at the start and the end, for all other months. To make each "month" unique, I used different number of blanks. Here is the script of the data, see Month1 field:
// Date =====================================
LET Start = num(makedate(2010,1,1));
LET End = floor(yearend(today()));
$(Start)-1+RecNo() as Date
AUTOGENERATE $(End) - $(Start) + 1;
JOIN (Date) LOAD
date(MonthStart(Date), 'MMM-YY') as Month,
year(Date) as Year
JOIN (Date) LOAD DISTINCT
if(mod(month(Month),3)=1,date(MonthStart(Month), 'MMM-YY'), chr(10)& repeat(' ', RowNo()) & chr(10)) as Month1
ORDER BY Month;
DROP TABLE tmp:
Field Month1 is what we need for the chart as dimension. It looks more or less OK if use vertical labels, not continuous. And, in Presentations limit legend (characters) to 6.
As Michael says, I want to show the division for all the months but only the description of the scale for the first month of the quarter
Very thanks for your response.
I tried what you said but did not get the expected result, in the following image is the graph as it was then.