Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]Graph - Month name vs number
Go
New
Search
Notify
Tools
Reply
  
[CLOSED]Graph - Month name vs number
 Login/Join
 
Gold member
posted
Hello

I am working on a graph which works fine in JSCHART format. But in PDF, I am having an issue. Month number displays on X axis from 1 to 12. I also have a month name field and I want that to display on X-axis and use month number field as sort. Please suggest.
   
GRAPH FILE TAB_NAME
SUM AMT AS ''
BY YEAR_VAL AS ''
ACROSS MONTH_NUM
ON GRAPH PCHOLD FORMAT PDF
ON GRAPH SET VZERO OFF
ON GRAPH SET AUTOFIT ON
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS INCHES
ON GRAPH SET HAXIS 8
ON GRAPH SET VAXIS 4
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setMarkerSizeDefault(50);
ENDSTYLE
END

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


WebFOCUS 8202
All formats
 
Posts: 71 | Registered: September 13, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Could you use NOPRINT on month number? Something like:

ACROSS MONTH_NUM NOPRINT
ACROSS MONT_NAME


WebFOCUS 8206, Unix, Windows
 
Posts: 1720 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Create a DEFINE field of format Mt and use it as the ACROSS field.
 
MONTH_Mt/Mt = MONTH_NUM;
 

Here is an example using the ggsales file:
 
DEFINE FILE ibisamp/ggsales
 Date_YYMD/YYMD = DATE ;
 Date_Mt/Mt = Date_YYMD; 
 Date_YY/YY = Date_YYMD ;
END
GRAPH FILE ibisamp/ggsales
SUM UNITS AS ''
BY Date_YY AS ''
ACROSS Date_Mt AS ''
ON GRAPH PCHOLD FORMAT PDF
ON GRAPH SET VZERO OFF
ON GRAPH SET AUTOFIT ON
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS INCHES
ON GRAPH SET HAXIS 8
ON GRAPH SET VAXIS 4
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setMarkerSizeDefault(50);
ENDSTYLE
END
 


WF 8.2.06
Win10 / IE11
AHTML EXL2K PDF
 
Posts: 141 | Registered: October 19, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]Graph - Month name vs number

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.