The problem is that the following code created with 7.6 Advanced Graph assistant is picking up the value for STATUS for both SITE and STATUS.

This is the line that is being passed:

http:///ibi_apps/WFServlet?IBIF_webapp=%2Fibi_apps&IBIC...osed&STATPAR=Closed&


SITEA should actually be a CITY name

-SET &ECHO=ALL;
-*WHERE VW_KPI_RPT.VW_KPI_RPT.SITE EQ &SITE.(OR (FIND VW_KPI_RPT.SITE IN VW_KPI_RPT));
-*WHERE VW_KPI_RPT.VW_KPI_RPT.SITE EQ &SITE.(OR (FIND VW_KPI_RPT.SITE IN VW_KPI_RPT)).SITE. ;
-*WHERE (VW_KPI_RPT.VW_KPI_RPT.DUE_DATE FROM '&FR_DATE' TO '&TO_DATE0');
-*INTERNAL_PROPERTIES$SampleData=false;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$GlobalRecordLimit=500;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$FieldDisplayMode=label;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$PrefixDisplayMode=;OBJECTID=GLOBAL
GRAPH FILE VW_KPI_RPT
-* Created by Advanced Graph Assistant
SUM CNT.VW_KPI_RPT.VW_KPI_RPT.VLD_TASK_ID
BY VW_KPI_RPT.VW_KPI_RPT.OPEN_CLOSE_STATUS NOPRINT
BY VW_KPI_RPT.VW_KPI_RPT.SITE
BY VW_KPI_RPT.VW_KPI_RPT.TIME_STATUS
WHERE (VW_KPI_RPT.VW_KPI_RPT.SITE EQ &SITE.(OR(FIND VW_KPI_RPT.SITE IN VW_KPI_RPT)).SITE.);
WHERE (VW_KPI_RPT.VW_KPI_RPT.TIME_STATUS NE ' ');
-*WHERE (VW_KPI_RPT.VW_KPI_RPT.CLOSE_DATE FROM &FR_DATE TO &TO_DATE0);
ON GRAPH PCHOLD AS HOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 1
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 2
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setPlace(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);
ENDSTYLE
ON GRAPH SET STYLE *
TYPE=DATA, COLUMN=N4, FOCEXEC=app/dg_open_rf(GDATE='&TO_DATE0' SITEA=VW_KPI_RPT.VW_KPI_RPT.SITE STATPAR=VW_KPI_RPT.VW_KPI_RPT.OPEN_CLOSE_STATUS ), $
ENDSTYLE
END

Tom
good thought however when we switchedto column referencing

TYPE=DATA, COLUMN=N4, FOCEXEC=app/dg_open_rf(GDATE='&TO_DATE0' SITEA=N2 STATPAR=N1 ), $

Which is all on one line we get the same results only the first and last value gets passed.

I did try your code and the same result.

Question does WEBFOCUS with the new advanced Graphics reconise and know where to find the middle value or in this case site.