Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Area Graph Break
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Area Graph Break
 Login/Join
 
Member
posted
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,


8201
 
Posts: 17 | Registered: April 20, 2018Reply With QuoteReport This Post
Platinum Member
posted Hide Post
hey all, I am Sherri's teammate. I found out how to resolve this. This ticket can be closed


WebFOCUS 8204
 
Posts: 119 | Registered: July 10, 2018Reply With QuoteReport This Post
Expert
posted Hide Post
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.




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
 
Posts: 3103 | Location: Middle Tennessee | Registered: February 23, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Area Graph Break

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.