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

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
Graphs
 Login/Join
 
<NIVAS>
posted
I am using date field on x-axis and Amount field on y-axis.How do i set the amount with intervals of $5000 and interval of 1 month on x-axis.
Any Ideas

Thanks in advance
 
Reply With QuoteReport This Post
Platinum Member
posted Hide Post
To set the x-axis to month, if you are using a proper date field (i.e. one in YYMD or similar format) do the following

DEFINE FILE filename
MONTH/M=mydatefield;
END
GRAPH FILE filename
SUM
mysumfield
BY MONTH
END

as for changing the interval on your y1 axis put the following in you graphstyle area of your code

setGridStep(getY1MajorGrid(),n);
setGridStepAuto(getY1MajorGrid(),false);

where n is the interval you want to use.

Note you can also do this by opening your graph in graph editor and going into you axis options, but in my version of WebFOCUS (436) graph editor is very temperamental, and has a habit of adding in styling I didn't want, and removing styling I did. It's much easier to enter the correct code directly into the graph.

Regards Tewy
 
Posts: 123 | Location: UK | Registered: October 09, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 


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