I have a table of data with REGION, SCORE, and TARGET. I want to create separate bullet graphs (essentially a horizontal bar graph) for each REGION of their SCORE and their TARGET as a reference line. I've been able to produce ONE bullet graph with this information - each region, one at a time. And... I'm able to display the bullet graphs without the TARGET as a reference line for each REGION (using one fex). I am perplexed, however, on how to dynamically display the correct target for the reference line when I have one fex displaying multiple region bullet graphs. Please help. Is this even possible?

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

Here is my code for graphing ONE bullet graph.

 
-SET &Measure = '008';
-*Target Data
-INCLUDE app/CoreMeasures_FYTarget.fex
-SET &FYTarget =
-IF &LINES EQ 0 THEN 'NA';
-RUN
-*Reading in saved variables
-READ FTARGETS &FYTarget.A22
-INCLUDE app/coremeasures_defines.fex
-*Defaults for &Date so the right information is pulled back
-PROMPT &Date;
-SET &SortDate =
-IF &Date EQ 'Fiscal Year' THEN 'Year1' ELSE
-IF &Date EQ 'Fiscal Quarter' THEN 'Quarter_Sort' ELSE
-IF &Date EQ 'Most Current Results' THEN 'MonthDatetime' ELSE 'MonthDatetime';
-*Grabing data to be displayed in chart
TABLE FILE CORE_MEASURES_WITH_COMPARATORS
PRINT
     Percent_of_Qualifying_Accounts/D12.1%
BY HIGHEST 1 &SortDate
WHERE Submission_Status1 EQ 'Final';
WHERE Measure_Set EQ 'Composite Quality Index - Heart Attack (AMI)';
WHERE Region EQ '&Region';
WHERE Facility EQ '&Facility';
ON TABLE HOLD AS SORT
END
-RUN
-* Setting the target line for the graph
-SET &Line = (EDIT(&FYTarget));
GRAPH FILE SORT
PRINT Percent_of_Qualifying_Accounts
BY &SortDate
ON GRAPH PCHOLD AS HOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET HAXIS 300
ON GRAPH SET VAXIS 70
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH HLINE
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setReportParsingErrors(false);
setSelectionEnableMove(false);
setPlace(true);
setTransparentBorderColor(getChartBackground(),true);
setDepthRadius(0);
setUseSeriesShapes(true);
setMarkerSizeDefault(50);
setDisplay(getY1MajorGrid(),false);
setDisplay(getO1MajorGrid(),false);
setTransparentBorderColor(getFrame(),true);
setSeriesType(getSeries(0),1);
setTransparentBorderColor(getSeries(0),true);
setFillColor(getSeries(0),new Color(0,0,0));
setRiserWidth(30);
setDisplay(getO1AxisLine(),false);
setDisplay(getO1Label(),false);
setTextString(getO1Title(),"");
setDisplay(getY1AxisLine(),false);
setTextString(getY1Title(),"");
setDisplay(getY1AltFmtFrame(),true);
setFontSizeAbsolute(getY1Label(), true);
setFontSizeInPoints(getY1Label(), 9);
setPlaceResize(getY1Label(), 0);
setY1ScaleMaxAuto(false);
setY1ScaleMax(100.0);
-*Added code
setAltFmtFrameNumColors(getY1AltFmtFrame(),2);
setAltFmtFrameSeparator(getY1AltFmtFrame(0),&Line);
setAltFmtFrameSeparator(getY1AltFmtFrame(1),100.0);
setFillColor(getY1AltFmtFrame(0),new Color(128,128,128));
setFillColor(getY1AltFmtFrame(1),new Color(192,192,192));
setReferenceLineValueY1(0,&Line);
setDisplay(getReferenceLineY1(0),true);
-*setLineWidth(getReferenceLineY1(0),2);
ENDSTYLE
END

 

It's not possible using amper variables unless each is created seperately.

look at creating an artificial series using compute and plot that series as a line