Focal Point
OMG---Oh My Graph!! First Graph and two of my percents are off by 2

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

March 23, 2011, 11:13 AM
MAdams1
OMG---Oh My Graph!! First Graph and two of my percents are off by 2
For all the graph experts, I hope you can help me. This is my first graph attempt and I am stumped. I've been scouring the forums for a similar issue but haven't found one. I get the report above the graph(good) which indicates the percents of 6%, 22%, 69%, and 3% for my pie graph(these are the correct percents). I am building off a hold file for my graph(hold file gives same percents) and when I run the graph ...the slices have 6%, 22%, 67%,and 5%......Can anyone see why my percents are off by two??? Thank you in advance. Michelle

-* File admit_apps_by_stud_type.fex
SET ASNAMES=ON
DEFINE FILE STUDENT_APPL_HISTORY_DIM
app_month/A4V=HNAME(STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.APPLICATION_DATE, 'MONTH', app_month);
app_mon_int/I2=DECODE app_month( JAN 1 FEB 2 MAR 3 APR 4 MAY 5 JUN 6 JUL 7 AUG 8 SEP 9 OCT 10 NOV 11 DEC 12 );
app_year/A4=HNAME(STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.APPLICATION_DATE, 'YEAR', app_year);
percent/P9%=STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM;
NEW_DAY_TIME/HMTDYYIA=HGETC(8, NEW_DAY_TIME);
END
-RUN
 
-***REPORT***
TABLE FILE STUDENT_APPL_HISTORY_DIM
SUM 
     'CNT.DST.STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM' AS ''
     'PCT.STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.percent' AS ''
BY 'STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.STUDENT_TYPE_DESC' AS ''
ON TABLE SUBHEAD
"Applicants by Student Type"
" "
WHERE STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.app_mon_int LE &app_mon_int.(<January,1>,<February,2>,<March,3>,<April,4>,<May,5>,<June,6>,<July,7>,<August,8>,<September,9>,<October,10>,<November,11>,<December,12>).app_mon_int.;
WHERE STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.APPLICATION_TERM_CODE EQ '&APPLICATION_TERM_CODE';
WHERE STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.app_year EQ '&app_year';
WHERE STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PROGRAM_OF_STUDY_CODE NE 'CD';
ON TABLE SET PAGE-NUM OFF 
ON TABLE SUMMARIZE STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.percent AS 'Total'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = kvcc_wf_no_logo,
$
TYPE=REPORT,
     GRID=OFF,
$
TYPE=DATA,
     BACKCOLOR=( 'WHITE' RGB(230 230 230) ),
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(230 230 230),
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(230 230 230),
$
ENDSTYLE
END
-***TABLE FILE FOR GRAPH***
TABLE FILE STUDENT_APPL_HISTORY_DIM
SUM 
     'CNT.DST.STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM' NOPRINT
 AS 'CNT_PIDMS'
     'CNT.DST.STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM' AS ''
     'PCT.STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.percent' AS ''
BY 'STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.STUDENT_TYPE_DESC' AS ''
ON TABLE SUBHEAD
"Applicants by Student Type"
" "
WHERE STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.app_mon_int LE &app_mon_int.(<January,1>,<February,2>,<March,3>,<April,4>,<May,5>,<June,6>,<July,7>,<August,8>,<September,9>,<October,10>,<November,11>,<December,12>).app_mon_int.;
WHERE STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.APPLICATION_TERM_CODE EQ '&APPLICATION_TERM_CODE';
WHERE STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.app_year EQ '&app_year';
WHERE STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PROGRAM_OF_STUDY_CODE NE 'CD';
ON TABLE SET PAGE-NUM OFF 
ON TABLE SUMMARIZE STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.percent AS 'Total'
ON TABLE HOLD AS STYPEHOLD FORMAT ALPHA
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = kvcc_wf_no_logo,
$
TYPE=REPORT,
     GRID=OFF,
$
TYPE=DATA,
     BACKCOLOR=( 'WHITE' RGB(230 230 230) ),
$
TYPE=TABHEADING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     SIZE=9,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(230 230 230),
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(230 230 230),
$
ENDSTYLE
END
DEFINE FILE STYPEHOLD
PERCENT/P9%=CNT_PIDMS;
NEW_DAY_TIME/HMTDYYIA=HGETC(8, NEW_DAY_TIME);
END
 
-***GRAPH***
GRAPH FILE STYPEHOLD
SUM PCT.STYPEHOLD.STYPEHOL.PERCENT AS 'Applicants by Student Type' 
BY STYPEHOLD.STYPEHOL.STUDENT_TYPE_DESC 
ON GRAPH SET LOOKGRAPH PIEMULTI
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D ON
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(1);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),2);
setPieFeelerTextDisplay(1);
setPieLabelDisplay(3);
setTextFormatPreset(getPieSliceLabel(),2);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontStyle(getY1Label(),2);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setFontStyle(getO1Label(),1);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
$
ENDSTYLE
END



WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML
March 23, 2011, 02:54 PM
Prarie
Look over this article


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
Prarie, The issue MAdams1 is having is that TWO of the percent numbers changed. The total still adds up to 100% but TWO of them changed values.

MAdams1, it looks like you are recalculating the percent in the GRAPH FILE section. Try adding an AS phrase to the PCT.STUDENT... in the TABLE FILE that creates the STYPEHOLD file. Then in the DEFINE before the GRAPH FILE change the PERCENT/P9%=[the AS for the PCT field in the HOLD File]. This might do the trick.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
MAdams1, Another thought is it looks like you could remove the PCT. on the 'PCT.STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.percent' field. If the field already contains a percent value then you do not need to perform a PCT. on the field. this may also be throwing off your numbers. This is because it performs a PCT using the values of the percent field whereas the DEFINE causes the PCT in the GRAPH FILE request to perform the percent calculation on a real count.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
Thanks Prarie. This article is great!


WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML
[SOLVED]

To Mickey,

Thanks..your second post did the trick. I also noticed I had some issues with my hold file. It's fixed. Thanks a bunch.


WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML