This is a bad example but the only data I could demonstrate with. We have a benchmark that ALWAYS has a value. When the two values we are bar graphing is 0 the benchmark does not show. Basically if you look at Sedan in my example you will see how the Retail cost area does not show because there is no Dealer Cost or My Cost for Maserati.

How do we make the area show even when the values do not exists?


-*COMPONENT=Define_carolap
DEFINE FILE baseapp/carolap
MyCost/D12.2= CAROLAP.BODY.RETAIL_COST ;
END
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
-DEFAULTH &WF_HTMLENCODE=OFF;
SET HTMLENCODE=&WF_HTMLENCODE

SET ARGRAPHENGINE=JSCHART
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT

SET EMBEDHEADING=ON
SET GRAPHDEFAULT=OFF
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';

-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE baseapp/carolap
-* Created by Info Assist for Graph
SUM CAROLAP.BODY.RETAIL_COST
CAROLAP.BODY.DEALER_COST
MyCost
BY CAROLAP.BODY.BODYTYPE
BY CAROLAP.COMP.CAR
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);

*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
TYPE=DATA, COLUMN=N1, BUCKET=row, $
TYPE=DATA, COLUMN=N2, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N4, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N5, BUCKET=y-axis, $
*GRAPH_SCRIPT

setReportParsingErrors(false);
setSelectionEnableMove(false);
setSeriesType(0,3);

*END
ENDSTYLE
END

-RUN

This message has been edited. Last edited by: FP Mod Chuck,

hey all, I am Sherri's teammate. I found out how to resolve this. This ticket can be closed

Brandon Andrathy,

Two Things:
1) Please post your solution, using the original code for the benefit of all Focal Point Users.

2) sherrihe: You can CLOSE this thread by editing the initial post and adding "[SOLVED] " to the beginning of your subject line.