Focal Point
graph data value for total of stacked values

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

November 13, 2007, 04:19 PM
Laure
graph data value for total of stacked values
I have a stacked bar graph on which I want to display ONLY the totla of the stacked bars.
The graph is buildt with underlying focus code similar to this:

sum cnt.cars
by country
across region

I found a
setDataTextStackedTotalOnTop(true) keyword in the WebFOCUS Keysheets on page 93. It certainly sounds like it would accomplish what I want... only I get a 'Possible Error on:setDataTextStackedTotalOnTop();' message.

Does anyone have a suggestion on how to accomplish this?


Laure


Prod: WebFOCUS 7.7.03 - MRE, BID, - WindowsXP - Oracle 9i, SQLServer, DevStudio 7.7.3 - Apache Tomcat , Output: HTML, Excel 2013 and PDF
November 13, 2007, 04:51 PM
Francis Mariani
quote:
setDataTextStackedTotalOnTop


I searched the Interwebs and IBI Tech Support and there's no mention of setDataTextStackedTotalOnTop.

There's no mention of it in the Perspective for Java documentation I have.

By the way, is GRAPH in WebFOCUS still using Perspective for Java? I just checked the Three D Graphics - Perspective for Java page and it states that the documentation was last updated on Oct. 2, 2000. There's nothing new since then?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 13, 2007, 05:57 PM
GinnyJakes
Francis,

IBI purchased the API and source code from 3D a number of years ago, I think at least 5. Since then they have incorporated it into the product and have produced their own version of the manual.

There is a manual called wf713graph.pdf on the 76x doc CD dated April of 2007.

Hope this helps.

The good news is that both the Graph Assistant and the Advanced version both generate a lot of the API that we used to have to hand-code after searching through the manual for just the right property to set.

Now if I could only get the AGA to work in Unix....


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
November 13, 2007, 05:59 PM
GinnyJakes
One more thing, Francis. In the bin directory of your 5.3 Dev Studio installation, there should be a graph API manual with a later date than 2000.


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
November 14, 2007, 09:18 AM
Danny-SRL
Laure,
You can find lots of documentation in the wf713graph.pdf manual.

I find that one can show cumulative totals for every stack layer but not the total only. Here is an example:
GRAPH FILE CAR
SUM CNT.CAR.COMP.CAR
BY CAR.BODY.BODYTYPE
ACROSS CAR.ORIGIN.COUNTRY
ON GRAPH SET 3D OFF
ON GRAPH SET GRID ON
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET GRMERGE ON
ON GRAPH SET VZERO ON
ON GRAPH SET GRAPHSTYLE *
setSeriesType(0,1);
setLegendDisplay(true);
setLegendMarkerPosition(0);
setMarkerDisplay(true);
setDataTextDisplay(true);
setStackedDataValueSum(true);
setGraphType(18);
setUseSeriesShapes(false);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setY1LabelDisplay(true);
setY1AxisSide(0);
setTextFormatPreset(getY1Label(),1);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setFontSize(getO1Label(),12);
setFontSizeAbsolute(getO1Label(),true);
setPlace(true);
ENDSTYLE
END



Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

November 14, 2007, 09:37 AM
Tom Flynn
Hi Laure (from Intersil???),

try this:

GRAPH FILE CAR
SUM CAR.BODY.DEALER_COST
CAR.BODY.SALES
CAR.BODY.RETAIL_COST
ACROSS CAR.ORIGIN.COUNTRY
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRAPHSTYLE *
setDisplay(getDataTextStackedTotalOnTop(), true);
setFillColor(getDataTextStackedTotalOnTop(),new Color(0,0,255));
setDataTextPosition(0);
setTextRotation(getDataTextStackedTotalOnTop(), 0);
setPlace(true);
END
-EXIT


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
November 14, 2007, 02:02 PM
VLozovsky
Laure,
Try running this procedure and see if that works for you.

GRAPH FILE CAR
SUM CNT.CAR
SEATS
BY CAR.ORIGIN.COUNTRY
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRAPHSTYLE *
setReportParsingErrors(false);
setPlace(true);
setDisplay(getDataTextStackedTotalOnTop(),true);
END

Vicky Lozovsky
November 14, 2007, 04:32 PM
Laure
Yes Tom, Intersil! Thanks
This gave me exactly what I was looking for.

setDisplay(getDataTextStackedTotalOnTop(), true);


Laure


Laure


Prod: WebFOCUS 7.7.03 - MRE, BID, - WindowsXP - Oracle 9i, SQLServer, DevStudio 7.7.3 - Apache Tomcat , Output: HTML, Excel 2013 and PDF