I would like to add an Trendline in to charts and it looks not working properly in WebFocus. We can get the trend line by using GTREND ON / setCurveFitType to get the trend line for the corresponding axis but that is not the one we are looking.

In Excel, the trendline works great and we can format it the way we want but not able to do that in WebFocus (version 8.0.0.8).

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
-* Created by Info Assist for Graph
SUM CNT.CAR.CARREC.MODEL
CAR.SPECS.LENGTH
CAR.SPECS.WIDTH
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
BY CAR.ORIGIN.COUNTRY
ON GRAPH PCHOLD FORMAT AHTML
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
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 VBRSTK2
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ARGRAPHENGINE=JSCHART, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDisplay(getDataText(4), true);
setDisplay(getDataText(3), true);
setCurveFitType(3,1);
setCurveFitType(2,1);
setCurveFitType(1,0);
setCurveFitType(4,1);
setSeriesType(4,2);
setSeriesType(3,2);
setSeriesType(0,1);
setSeriesType(1,1);
setAxisAssignment( $0, 0);
setAxisAssignment( $1, 0);
setAxisAssignment( $2, 0);
setAxisAssignment( $3, 1);
setAxisAssignment( $4, 1);
setDisplay(getDataText(1), false);
setDisplay(getDataText(0), false);
setDisplay(getDataText(2), false);
*END
ENDSTYLE
END
-RUN

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

What kind of trendline are you trying to add?

WebFOCUS Charts have Linear, Quadratic, Polynomial, Hyperbolic, Logarithmic, Modified Hyperbolic Rational, Exponential, Modified Exponential, Log Quadratic and Geometeric.

Are you saying none of these work? I just tried Linear in 8105 and it works for me.

To get to any of these, you need to pick the Series Tab and click Trendline. You get the list of available types.

Hi,

Create a Dual Axis Vertical stack bar chart (Y1 axis - 3 fields, Y2 axis - 2 field) and create the trend line on 2 field on the y2 axis and see whether that works for you.

And also, you are trying it in 8105 version. We are in 8008 version.

Thanks

Just tested what you described and I get a trend line for both or either one of the Y2 fields in 8105.

Here's the code I get when I create this chart.

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
-* Created by Info Assist for Graph
SUM CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
CAR.BODY.SALES
CAR.SPECS.WIDTH
CAR.SPECS.LENGTH
BY CAR.ORIGIN.COUNTRY
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH SET VZERO 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 VBAR2AX
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);

*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
*GRAPH_SCRIPT

setReportParsingErrors(false);
setSelectionEnableMove(false);
setSmoothLines(false);
setSeriesType(3,1);
setAxisAssignment( $0, 0);
setAxisAssignment( $1, 0);
setAxisAssignment( $2, 0);
setAxisAssignment( $3, 1);
setAxisAssignment( $4, 1);
setCurveFitType(1,0);
setCurveFitType(0,2);
setCurveFitType(3,0);
setCurveFitType(4,2);

*END
ENDSTYLE
END

-RUN

change your code to use Dual axis vertical stack bar chart (VBRSTK2) not Vertical bar chart (VBAR2AX).

I still see the trendline.

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
-* Created by Info Assist for Graph
SUM CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
CAR.BODY.SALES
CAR.SPECS.LENGTH
CAR.SPECS.WIDTH
BY CAR.ORIGIN.COUNTRY
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH SET VZERO 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 VBRSTK2
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);

*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
*GRAPH_SCRIPT

setReportParsingErrors(false);
setSelectionEnableMove(false);
setSmoothLines(false);
setSeriesType(3,1);
setCurveFitType(1,0);
setCurveFitType(0,2);
setAxisAssignment( $0, 0);
setAxisAssignment( $1, 0);
setAxisAssignment( $2, 0);
setAxisAssignment( $3, 1);
setAxisAssignment( $4, 1);
setCurveFitType(3,1);
setCurveFitType(4,1);

*END
ENDSTYLE
END

-RUN

It works in 8.0.09.

you will see a trend line but does it shows near the field you selected for trend.

For us, the field is showing the line on the top and the trend line is showing bottom.

Hello,

The behavior you are describing is a known issue which is being evaluated by programming presently. You are experiencing this issue in version 8.0.07, is that correct?

Emily McAllister
Focal Point Moderator