Focal Point
[SOLVED] Display only min and max values on an axis

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6547084786

August 11, 2017, 11:11 AM
pbmdo1
[SOLVED] Display only min and max values on an axis
I need to present a graph that on a given axis only displays the min and max values/labels. I have tried varying combinations of set and get commands and have failed to achieve my goal.

Does anyone have a suggestion?

Thank you

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


Director-Business Intelligence
WebFOCUS 8.09
Windows, All Outputs
August 11, 2017, 11:19 AM
MartinY
Can you be more specific and detailed, I'm not sure to understand your need ?

Give a sample if possible.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
August 11, 2017, 11:52 AM
pbmdo1
I have a line chart and what I need on the axis is a min value ( ie 0) at the left of the x axis and a max value (ie 60) at the end on the right of the x axis. No values in between.

Thank you


Director-Business Intelligence
WebFOCUS 8.09
Windows, All Outputs
August 11, 2017, 12:00 PM
MartinY
Something such as this ?
ENGINE INT CACHE SET ON
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE CAR
SUM COMPUTE PCT/D6= IF COUNTRY EQ 'ENGLAND' THEN 0 ELSE 60; AS ''
BY COUNTRY AS ''
WHERE COUNTRY EQ 'FRANCE' OR 'ENGLAND';
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
setUseSeriesShapes(true);
setMarkerSizeDefault(50);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
ENDSTYLE
END
-RUN



WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
August 11, 2017, 12:08 PM
pbmdo1
How do I suppress the 10, 20, 30, 40, 50 values from showing on the graph.

Thank you


Director-Business Intelligence
WebFOCUS 8.09
Windows, All Outputs
August 11, 2017, 12:19 PM
pbmdo1
Here are some of the set and get commands I have been attempting but these have not worked exactly the way I want them to.


setTextFormatPattern(getY1Label(), "#");
setTextFormatPreset(getY1Label(), -1);
setScaleMax(getY1Axis(),&METRIC_MAX);
setScaleMaxAuto(getY1Axis(),false); -* Controls the MAX scale and segments
setScaleMin(getY1Axis(),&METRIC_MIN); -* Y AXIS VALUE
setScaleMinAuto(getY1Axis(),false); -* Controls the MIN scale and segments
setScaleMaxAuto(getY1Axis(),false);
setScaleMinAuto(getY1Axis(),false);
setScaleMin(getY1Axis(),&METRIC_MIN);
setScaleMax(getY1Axis(),&METRIC_MAX);


Director-Business Intelligence
WebFOCUS 8.09
Windows, All Outputs
August 11, 2017, 01:18 PM
MartinY
Is that what you're looking for ?
setScaleMinAuto(getY1Axis(),false);
setScaleMaxAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),60.0);
setGridStepAuto(getY1MajorGrid(),false);
setGridStep(getY1MajorGrid(),60.0);



WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
August 11, 2017, 02:17 PM
pbmdo1
Yes very helpful..

Thank you


Director-Business Intelligence
WebFOCUS 8.09
Windows, All Outputs
August 11, 2017, 02:25 PM
MartinY
My pleasure.

Please edit your first post then add [SOLVED] at the beginning of the subject.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
August 11, 2017, 02:28 PM
pbmdo1
Will do. Again Thank you


Director-Business Intelligence
WebFOCUS 8.09
Windows, All Outputs