quote:

Originally posted by Larry Eiss:
[qb] Tariq,

Curve fitting in WebFOCUS Graphs is very flexible. Below is a FEX you can run against the CAR file to see an example. After the FEX I have more comments, so be sure to scroll down.

-------- BEGIN FEX --------
-* File CurveFit.FEX
GRAPH FILE CAR
SUM SALES
ACROSS COUNTRY
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setX1LabelDisplay(true);
setX1AxisSide(0);
setX1MajorGridDisplay(true);
setX1MajorGridStyle(0);
setX1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieDepth(0);
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setLegendDisplay(true);
setLegendTextAutofit(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getX1Title(),true);
setO1LabelAutofit(true);
setCurveFitType(0,2);
setCurveFitEquationDisplay(false);
ENDSTYLE
END
----------- END FEX ----------

Notice the last two lines above the ENDSTYLE statement. This is the code that creates the trend line.

Below is some information on the various curve fitting options available to you. To use these you would replace the digit "2" in the setCurveFitType() call above with one of the values below.

CurveFitType
Value Description
0 None
1 Linear regression curve fit line
2 Quadratic curve fit line
3 Polynomial fit line
4 Hyperbolic curve fit line
5 Logarithmic curve fit line
6 Modified hyperbolic
7 Rational curve fit line
8 Exponential curve fit line
9 Modified exponential
10 Logarithmic/Quadratic curve fit line
11 Geometric curve fit line

I hope this proves helpful,
--WebFOCUS Product Management [/qb]

quote:

Originally posted by FrankDutch:
What should be the basic value for the trend analyzes? The sum of the stacked value, or the individual values (that would give several trends)

What you can do, is calculate the wanted trend in the fex that collects the data and ad that line as an extra field in the graph. (not stacked)

GRAPH FILE CAR
SUM RETAIL_COST DEALER_COST SALES
ACROSS COUNTRY
ON GRAPH SET LOOKGRAPH MULTI3Y
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setX1LabelDisplay(true);
setX1AxisSide(0);
setX1MajorGridDisplay(true);
setX1MajorGridStyle(0);
setX1MinorGridDisplay(false);
setPieDepth(0);
setFontSizeAbsolute(getX1Title(),true);
setCurveFitEquationDisplay(false);
setCurveFitType(0,5);
setCurveFitPolynomialOrder(0,3);
setCurveFitType(1,5);
setCurveFitPolynomialOrder(1,3);
setCurveFitType(2,5);
setCurveFitPolynomialOrder(2,3);
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setAxisAssignment(1,1);
setAxisAssignment(2,2);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE

	Frank
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7