Focal Point
[SOLVED] AGA: Stacked Bars/Line not adding the series

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

November 25, 2009, 10:49 AM
Stefan
[SOLVED] AGA: Stacked Bars/Line not adding the series
Hi,

I'm loking for a way to display a graph with stacked bars or lines, where the series are NOT added (similar to Microsoft Excel).

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


WF 7.6.9
PMF 5.1.3
BID 7.6.9

Win XP
HTML, PDF, Excel, PowerPoint
December 03, 2009, 08:37 AM
<JG>
Only options are either an absolute line graph type 48 or an absolute area graph type 31 .

There is not a bar version.
December 10, 2009, 02:38 AM
Stefan
I just recognized that my question was wrong.
It should be like this:

I want a graph with stacked bars.
The series shall be added (like AGA does).

But:
AGA addes the display values (labels?) of each series.

I want to display the "original" labels.

E.g.:

My original series is
A: 1
B: 5
C: 10

AGA display the following values:
A: 1
B: 6
C: 16

and I want to display the Original values.


WF 7.6.9
PMF 5.1.3
BID 7.6.9

Win XP
HTML, PDF, Excel, PowerPoint
December 10, 2009, 04:38 AM
<JG>
Stefan

That is the default behavior

You need setStackedDataValueSum(false);

In the AGA this can be set in the chart editor

Chart Objects/Chart/Data Labels

Change the value of "Show cumulative sums" to No
December 10, 2009, 09:37 AM
Stefan
JG,

that's great and works fine. Sometimes life can be so easy. Thank you.

Now I have still one issue left:

I've got my bar
A: 1
B: 5
C: 10

showing each value correct.

Above each bar, I would like to diplays the sum of the single values of each bar.

I tried
setDisplay(getDataTextStackedTotalOnTop(),true)

like in these post,
but it doesn't work.

 GRAPH FILE myFile
-* Created by Advanced Graph Assistant
SUM myMeasure1
myMeasure2
myMeasure3
BY CALMONTH_NAME NOPRINT
BY CALMONTH_DESCRIPTION
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET HAXIS 600
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 2
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setDepthRadius(0);
setUseSeriesShapes(true);
setMarkerSizeDefault(50);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setDisplay(getDataText(),true);
setTextFormatPreset(getDataText(),-1);
setTextFormatPattern(getDataText(),"###,###");s
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"###,###");
setTextString(getO1Title(),"");
setTextString(getY1Title(),"");
setFontStyle(getY1Title(),0);
setScaleMustIncludeZero(getY1Axis(),false);
setTextString(getTitle(),"lorem ipsum");
setDisplay(getTitle(),true);
setFontStyle(getTitle(),0);
setFontSizeAbsolute(getTitle(),true);
setFontSizeInPoints(getTitle(),10);
setPlaceResize(getTitle(),0);
setFontName(getTitle(),"Arial");
setTextString(getSubtitle(),"myTitle");
setDisplay(getSubtitle(),true);
setFontStyle(getSubtitle(),0);
setFontName(getSubtitle(),"Arial");
setFontSizeAbsolute(getSubtitle(),true);
setFontSizeInPoints(getSubtitle(),10);
setPlaceResize(getSubtitle(),0);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeInPoints(getY1Label(),8);
setPlaceResize(getY1Label(),0);
setFontName(getY1Label(),"Arial");
setFontName(getO1Label(),"Arial");
setFontSizeAbsolute(getO1Label(),true);
setFontSizeInPoints(getO1Label(),8);
setPlaceResize(getO1Label(),0);
setFillColor(getSeries(0),new Color(0,90,147));
setLineWidth(getSeries(0),2);
setMarkerSize(getSeries(0),25);
setTextRotation(getO1Label(),3);
setExtendToFrameEdge(false);
setFontName(getDataText(),"Arial");
setFontSizeAbsolute(getDataText(),true);
setFontSizeInPoints(getDataText(),8);
setPlaceResize(getDataText(),0);
setFontStyle(getDataText(),0);
setFillColor(getDataText(),new Color(128,128,128));
setFillColor(getY1Label(),new Color(128,128,128));
setFillColor(getO1Label(),new Color(128,128,128));
setTextRotation(getY1Label(),0);
setDataTextRadiusDefault(30);
setDataTextAngleDefault(45);
setFillColor(getSeries(1),new Color(163,189,217));
setFillColor(getSeries(2),new Color(110,150,194));
setFillColor(getLegendText(),new Color(128,128,128));
setFontName(getLegendText(),"Arial");
setFontSizeAbsolute(getLegendText(),true);
setFontSizeInPoints(getLegendText(),7);
setPlaceResize(getLegendText(),0);
setMarkerSize(getSeries(1),25);
setMarkerSize(getSeries(2),25);
setMarkerShape(getSeries(1),6);
setTextWrap(getCurveFitEquationText(),false);
setCustomDataText(getDataText(0),true);
setCustomDataText(getDataText(2),true);
setRiserWidth(50);
setTransparentFillColor(getFrame(),false);
setTransparentBorderColor(getFrame(),true);
setSeriesType(getSeries(1),0);
setForceSeriesAbsolute(getSeries(1),false);
setForceSeriesAbsolute(getSeries(0),false);
setCustomDataText(getDataText(1),true);
setStackedDataValueSum(false);
setDisplay(getDataTextStackedTotalOnTop(),true);
setFillColor(getDataTextStackedTotalOnTop(),new Color(255,0,0));
setDataTextPosition(0);
setTextRotation(getDataTextStackedTotalOnTop(), 0);
ENDSTYLE
END 


I would really appreciate any ideas.

Kind regards,

Stefan


WF 7.6.9
PMF 5.1.3
BID 7.6.9

Win XP
HTML, PDF, Excel, PowerPoint
December 11, 2009, 03:03 PM
GinnyJakes
Stefan,

I got this technique from a Summit 2009 presentation and had actually presented part of it at a monthly consulting session I did. I learned a lot from going through the presentation.

What I did was make a series out of the total value and held it along with the other values. It became series 3 in the example. I turned off the background color and border color for this series. I did this all in the Advanced Graph Assistant.

You will probably need to use custom placement for the series values but hopefully this will give you some ideas for solving your problem:
-* File car_stacked_bar_sum_off.fex
TABLE FILE CAR
SUM DEALER_COST
    RETAIL_COST
 SALES
COMPUTE TOT_DOLLARS/D8=C1+C2+C3;
BY COUNTRY
ON TABLE HOLD AS HTOTAL FORMAT ALPHA
END
-*? HOLD HTOTAL
-*-EXIT
-*INTERNAL_PROPERTIES$SampleData=false;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$GlobalRecordLimit=500;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$FieldDisplayMode=label;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$PrefixDisplayMode=;OBJECTID=GLOBAL
GRAPH FILE HTOTAL
-* Created by Advanced Graph Assistant
SUM HTOTAL.HTOTAL.DEALER_COST
HTOTAL.HTOTAL.RETAIL_COST
HTOTAL.HTOTAL.SALES
HTOTAL.HTOTAL.TOT_DOLLARS
BY HTOTAL.HTOTAL.COUNTRY
ON GRAPH PCHOLD AS HOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setDisplay(getDataText(),true);
setStackedDataValueSum(false);
setMarkerShape(getSeries(3),0);
setSeriesType(getSeries(3),0);
setDataTextPosition(4);
setTransparentFillColor(getSeries(3),true);
setTransparentBorderColor(getSeries(3),true);
setDisplay(getDataTextStackedTotalOnTop(),false);
ENDSTYLE
END



Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google