Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] AGA: Stacked Bars/Line not adding the series

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] AGA: Stacked Bars/Line not adding the series
 Login/Join
 
Gold member
posted
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
 
Posts: 69 | Location: Germany | Registered: September 21, 2009Report This Post
<JG>
posted
Only options are either an absolute line graph type 48 or an absolute area graph type 31 .

There is not a bar version.
 
Report This Post
Gold member
posted Hide Post
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
 
Posts: 69 | Location: Germany | Registered: September 21, 2009Report This Post
<JG>
posted
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
 
Report This Post
Gold member
posted Hide Post
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
 
Posts: 69 | Location: Germany | Registered: September 21, 2009Report This Post
Expert
posted Hide Post
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
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] AGA: Stacked Bars/Line not adding the series

Copyright © 1996-2020 Information Builders