Hello fellow WebFOCUS nail bangers!

I am trying to create a graph with a date field, YRMN /YYM (displays like ‘201411’) in a graph, but I want it to display like ‘Nov-2014’ in the graph along the X-Axis. To do so I created a field MYDATE (displays like ‘Nov-2014’).

I get the desired result in a table request when I code:

 
TABLE FILE CAR
SUM CNT.MPIID AS 'Total, Encounters'
ACROSS YRMN NOPRINT
ACROSS MYDATE AS 'MONTH'
BY ENCOUNTERTYPE AS ' T'
END
 

However, if I code it in a graph,

 
TABLE FILE CAR
SUM CNT.MPIID AS ' Total, Encounters '
ACROSS YRMN NOPRINT
ACROSS MYDATE AS 'MONTH'
BY ENCOUNTERTYPE AS ' '
END

In the graph the MYDATE is displayed for every axis label.
Yuk!

Now I understand that just one ACROSS is supported in WF8 graphs.

Dreck!

Does anyone have a suggestion that could solve this?

I am working with WebFOCUS 8.1.05 InfoAssist.

Thank you!

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

Is there an option to merge the graphs ?

GRMERGE ON

Grmerge is ON

Frustrating.....

quote:

Originally posted by Tomsweb:
I want dates like 01-2012, 02-2012 to display along the X-axis in a graph of car sales across date by dealer_cost. How's that sound for a car file prototype?

Right now dates look like 201201, 201202.

Can you change the format from YYM to MtYY ?

I am not familiar with InfoAssist as we're using 7.6.11 here. In that using BY instead of ACROSS yields your desired result.

Is that an option for you?

quote:

MtYY ?

I created a new field in the MtYY format. That means I can use that in a single ACROSS in my graph, so it worked.

Thanks to all for your help.