Focal Point
[CLOSED] Cylinder Bar Graph

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

November 01, 2010, 04:45 PM
cmarty
[CLOSED] Cylinder Bar Graph
Hi! Does anyone know how to change the rectangular bars to cylinder shaped bar in a bar graph?

I tried using the 3dcylinder template but it still looks like a rectangle.

thanks,
Cassandra

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


WF7.6, Windows
all output
November 01, 2010, 04:59 PM
Waz
Have you checked out the WebFOCUS Graphics documentation, or gone to see the ThreeDGraphics site.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

November 03, 2010, 12:46 PM
cmarty
i checked out the webfocus graphics but not helpful.

i went to the java site-- how do i implement that in webfocus??


WF7.6, Windows
all output
November 03, 2010, 05:14 PM
Waz
ThreedGraphics is the supplier of WebFOCUS Graphics.

It has many options thay may not be in the WebFOCUS documentation, and may be able to be implemented.

For example Graph Type 3 is a 3d Cylinder Graph.

e.g.
GRAPH FILE CAR
SUM CAR.BODY.DEALER_COST
BY CAR.ORIGIN.COUNTRY NOPRINT
BY CAR.CARREC.MODEL
ACROSS CAR.BODY.SEATS
ON GRAPH PCHOLD AS HOLD FORMAT PNG
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 1
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setGraphType(3);
-*setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
TYPE=DATA, ACROSSCOLUMN=N1, FOCEXEC=ANOTHERFEX(MODEL=CAR.CARREC.MODEL), $
ENDSTYLE
END



Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

November 06, 2010, 10:51 AM
cmarty
Waz, thanks for your direction. I tried all the the different graphs but cannot find the one that I want.

Please see the link of the graph I want to build. Any thoughts? Basically they are cylinder Bar Graphs.




WF7.6, Windows
all output
November 08, 2010, 01:13 PM
M Meagher
This is as close as I could get with the Advanced Graph Editor

 
GRAPH FILE CAR
-* Created by Advanced Graph Assistant
SUM MPG
BY MODEL
WHERE COUNTRY EQ 'ENGLAND' OR 'JAPAN'
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBICylinderOnGrey.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5); 
setTransparentBorderColor(getChartBackground(),true); 
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);
setPlace(true);
setSeriesType(getSeries(0),1);
ENDSTYLE
END

November 08, 2010, 04:30 PM
Waz
I've been fiddling with the graph for 2 days. Very frustrating....

Best I can do is
GRAPH FILE CAR
SUM CAR.BODY.DEALER_COST
ACROSS CAR.ORIGIN.COUNTRY
ON GRAPH SET LOOKGRAPH 3DCYLDER
ON GRAPH SET GRAPHEDIT OFF
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
-*ON GRAPH SET VAXIS 405.000
-*ON GRAPH SET HAXIS 770.000
ON GRAPH SET UNITS PIXELS
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setCubeFocusFactor(50.0);
-*setCubeLightSourceZ(90.0);
-*setCubeLightSourceY(15.0);
-*setCubeLightSourceX(3.0);
setCubePanX(60.0);
setCubePanY(40.0);
setCubeRotationMatrix(0,-80,0);
-*setCubeSizeX(20.0);
-*setCubeSizeY(35.0);
-*setCubeSizeZ(30.0);
-*setCubeSquareRisers(false);
setCubeTranslationZ(90.0);
setCubeTranslationY(42.5);
setCubeTranslationX(65.0);
setCubeViewerX(50.0);
setCubeViewerY(60.0);
setCubeViewerZ(36.8);
setCubeWallThickX(5.0);
setCubeWallThickY(5.0);
setCubeWallThickZ(5.0);
setCubeZoomFactor(60.0);

setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setLegendDisplay(true);
setLegendTextAutofit(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setO1LabelAutofit(true);
setPlace(false);
ENDSTYLE
END


I can't seem to find any good documentation of cube rotation.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

June 27, 2011, 12:04 PM
Sayed
Is the Cylinder Bar Graph "screen shot above" possible in WF? We're using WF 7702.


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE