TABLE FILE F_QLTY_MEDERROR
  SUM CNT.F_QLTY_MEDERROR.F_QLTY_MEDERROR.ERROR_LEVEL
   BY F_QLTY_MEDERROR.D_SPECIALTY.DESCRIPTION
   BY HIGHEST 10 F_QLTY_MEDERROR.D_TIME.TIME_YEAR
WHERE F_QLTY_MEDERROR.D_TIME.TIME_YEAR GE 2005;
WHERE F_QLTY_MEDERROR.D_GEOGRAPHY.GEOG_REGION_DESC EQ '&GEOG_REGION_DESC.(FIND F_QLTY_MEDERROR.D_GEOGRAPHY.GEOG_REGION_DESC IN F_QLTY_MEDERROR).Geog_region_desc:.';
WHERE F_QLTY_MEDERROR.D_SERVICECENTERTYPE.SERVICECENTER_NAME EQ &SERVICECENTER_NAME.(OR(FIND F_QLTY_MEDERROR.D_SERVICECENTERTYPE.SERVICECENTER_NAME IN F_QLTY_MEDERROR)).Servicecenter_name:.;
   ON TABLE HOLD
END
-*
-*INTERNAL_PROPERTIES$fieldDisplayMode=label;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$enablePreview=true;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$prefixDisplayMode=;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$GlobalRecordLimit=500;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$SampleData=false;OBJECTID=GLOBAL
GRAPH FILE HOLD
-* Created by Advanced Graph Assistant
SUM ERROR_LEVEL
BY DESCRIPTION
ACROSS TIME_YEAR
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET HAXIS 985
ON GRAPH SET VAXIS 518
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.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);
setTextString(getY1Title(),"Medication Error");
setDisplay(getY1Title(),true);
setFillColor(getO1Title(),new Color(0,0,0));
setLegendPosition(2);
setTransparentFillColor(getLegendArea(),false);
setFillColor(getLegendArea(),new Color(239,239,239));
setTransparentBorderColor(getLegendArea(),false);
setTextString(getTitle(),"Total Medication Error");
setDisplay(getTitle(),true);
setTextString(getSubtitle(),"By Specialty");
setDisplay(getSubtitle(),true);
setTextString(getO1Title(),"Last 5 Years");
setDisplay(getO1Title(),true);
ENDSTYLE
ON GRAPH SET STYLE *
TYPE=DATA, ACROSSCOLUMN=N1, FOCEXEC=mederrorspecialtyreport, TARGET=_blank, $
ENDSTYLE
END

TABLE FILE F_QLTY_MEDERROR
SUM 
'CNT.F_QLTY_MEDERROR.F_QLTY_MEDERROR.ERROR_LEVEL'

TABLE FILE F_QLTY_MEDERROR
SUM 
'CNT.F_QLTY_MEDERROR.F_QLTY_MEDERROR.ERROR_LEVEL' AS CNT_ERROR

GamP

---

- Using AS 8.2.01 on Windows 10 - IE11.
	in Focus since 1988

TABLE FILE F_QLTY_MEDERROR
SUM 
     'CNT.F_QLTY_MEDERROR.F_QLTY_MEDERROR.ERROR_LEVEL' AS ERRORLEVEL
BY 'F_QLTY_MEDERROR.D_SPECIALTY.DESCRIPTION' AS DESCRIPTION
RANKED AS 'TOP' BY HIGHEST 10 'F_QLTY_MEDERROR.F_QLTY_MEDERROR.ERROR_LEVEL' 
WHERE
...;
ON TABLE NOTOTAL
ON TABLE HOLD
ON TABLE SET ASNAMES ON
...
END
-RUN

GRAPH FILE HOLD
-* Created by Advanced Graph Assistant
SUM ERROR_LEVEL

ACROSS DESCRIPTION
BY ERROR_LEVEL

ON GRAPH PCHOLD FORMAT PNG...