Below is an example of a chart that has the HDATE function working and it allows me to sot the months just fine but does not take the year into account.


DEFINE FILE widgets
MONTHYR/I6MtYY = HDATE(COMPLETE_DATE, 'YYMD');
END

GRAPH FILE widgets
SUM WIDGETCOUNTS
BY MANAGER
ACROSS MONTHYR

My data set will be a rolling 12 month so it will cross years.

With this DEFINE the X axis looks like this:

Jan 2016 Feb 2016 March 2016 April 2015 April 2016 May 2015 May 2016 etc.

I need it to recognize the year so that the graph will begin at April 2015 and end with April 2016 then next month will show May 2015 to May 2016 and so on. This will change each month so creating the columns is not an option.

Is there a format where the sort will take the year into account and also be able to display on the X axis as MtYY?

This message has been edited. Last edited by: <Emily McAllister>,

Did you try
ACROSS LOWEST COMPLETE_DATE NOPRINT
ACROSS MONTHYR

That is the first thing that I tried.... It renders the chart with he Complete_Date data like its ignoring the NOPRINT. It also forces me to change the ON GRAPH SET GRAXIS from 1 to 2 I saw in some other posts that Versions after 8.0 do not allow two chart across fields. I am using APP Studio 8105.

Well, then what about holding the data sorted in the correct order and then do the graph from that hold file using the one across.

Or... Can you just do a BY COMPLETE_DATE NOPRINT and avoid the double ACROSS?

This message has been edited. Last edited by: Vivian,

I am still unable to resolve this.... The graph sorts the X - axis based on the first ACROSS field even if it is NOPRINT. It ignores the NOPRINT which seems crazy to me. So I can not use a hold file and can not use an extra BY to get the X axis the way the consumer wants it.
I saw a post by Ginny Jakes back in 2007 that touched on the issue of sorting by month number and display month name but I am using WF 8105. So I would think there would be a better way..... And actually I can get the month to sort correct its the year that isn't cooperating...

What does the Master - metadata - look like for that field? Can you have the usage mmddyy and keep the actual as yymmdd type format?

Hard to solve without looking at it... but hmmm

Try this:

 
DEFINE FILE widgets
MONTHYR/I6MtYY = HDATE(COMPLETE_DATE, 'YYMD');
MONTHYR2/MtYY = MONTHYR;
END

GRAPH FILE widgets
SUM WIDGETCOUNTS
BY MANAGER
ACROSS MONTHYR2 

Hi - This worked just as I need it to. Thank you!! One little thing though - The out put is like this - MAY, 2016. How do I get rid of the comma? I tried with this format: Mt|YY. But then the report gets an error.