Focal Point
[CASE-OPENED] Pie Graph Displays A Single Line, Not the Pie

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

May 08, 2009, 12:19 PM
Laurie
[CASE-OPENED] Pie Graph Displays A Single Line, Not the Pie
I have a situation where the Pie Graph only displays a line and does not display the rest of the graph. The parameters are distance and country. For example 2 countries, Canada and US and the distance for Canada is 594 while the distance for the US is 13,336,248.

Has anyone seen this problem before?

This message has been edited. Last edited by: Kerry,
May 11, 2009, 01:41 PM
Laurie
I was able to reproduces this problem with the car tables. If you feel this is a bug, I will enter a case.

-* File Graph Bug

GRAPH FILE CAR
SUM DEALER_COST NOPRINT
COMPUTE TestGraph/D12.2 = IF COUNTRY EQ 'W GERMANY' THEN DEALER_COST + 1000000 ELSE 500;
BY COUNTRY
WHERE COUNTRY EQ 'W GERMANY' OR 'FRANCE';

ON GRAPH HOLD AS HOLD FORMAT SVG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET HAXIS 7.8
ON GRAPH SET VAXIS 4
ON GRAPH SET UNITS INCHES
ON GRAPH SET LOOKGRAPH PIESINGL
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBITrueColors.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setPieFeelerTextDisplay(1);
setReverseSeries(false);
setLegendPosition(2);
setDisplay(getPieLabel(),false);
setPlace(false);
setPlaceResize(getPieSliceLabel(),1);
setFontName(getPieSliceLabel(),"Arial");
setFontName(getLegendText(),"Arial");
setFontName(getSubtitle(),"Arial");
setTextString(getTitle(),"");
setTextString(getSubtitle(),"Graph Title");
setDisplay(getSubtitle(),true);
setFontSizeAbsolute(getSubtitle(),true);
setFontSizeInPoints(getSubtitle(),8);
setFontStyle(getSubtitle(),0);
setPlaceResize(getLegendText(),0);
setFontSizeAbsolute(getLegendText(),true);
setFontSizeInPoints(getLegendText(),6);
setFontSizeAbsolute(getPieSliceLabel(),true);
setFontSizeInPoints(getPieSliceLabel(),6);
setFillColor(getChartBackground(),new Color(255,255,255));
setTransparentBorderColor(getChartBackground(),true);
setPieDepth(0);
setPieTilt(0);
setOtherPieLabelDisplay(0);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setLegendTextAutosize(true);
ENDSTYLE
END

END
-RUN
TABLE FILE SYSCOLUM
" "
SUM TBNAME NOPRINT
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
type=HEADING, IMAGE=HOLD.svg, position=(-1 0), $
TYPE=REPORT,PAGE-LOCATION=OFF,$
END
May 11, 2009, 02:17 PM
GinnyJakes
I think it is not that the graph is displaying as a single line. It is more that you can't see W GERMANY. The black line is FRANCE. It looks like that because the scales are so out of wack from each other. It dies at 100,000. 10,000 works.

This looks like a bug to me that is scale-related. I'd open a case if I were you.


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
May 12, 2009, 07:45 AM
<JG>
The problem is specific to SVG, GIF and JPEG are just fine.

However remove the sizing attributes from the graph code and add
them to the report stylesheet if needed.

However if you want to see something really weird

Remove the line setPieDepth(0) and also try changing it's value to 100

This message has been edited. Last edited by: <JG>,