Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

I want to Hide Missing / Zero Data in the Chart, within Info...


Douglas Lee 2

Recommended Posts

I changed the SALES Define to have MISSING ON and no quotes on MISSING like this:

SALES/D12C MISSING ON =IF YEAR EQ '97' AND MONTH GE '07' AND GGSALES.SALES01.CATEGORY EQ 'Gifts' THEN MISSING ELSE DOLLARS;

 

Seems to work:

 

image.png36231381 206 KB

Link to comment
Share on other sites

I want to Hide Missing / Zero Data in the Chart, within InfoAssist (of text if needed).

Should my DEFINE use a Zero or MISSING Or, is the something to add in the STYLESHEET, which is not in IA Or, something else

The CODE follows the image.

 

image.png968532 39.7 KB

 

-*COMPONENT=Define_ggsales

DEFINE FILE ibisamp/ggsales

YEAR/A4=EDIT(EDIT(DATE),$$99);

MONTH/A2=EDIT(EDIT(DATE),$$$$99);

SALES/D12C=IF YEAR EQ 97 AND MONTH GE 07 AND GGSALES.SALES01.CATEGORY EQ Gifts THEN MISSING ELSE DOLLARS;

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_ARVERSION=2;

SET ARVERSION=&WF_ARVERSION

-DEFAULTH &WF_STYLE_UNITS=PIXELS;

-DEFAULTH &WF_STYLE_HEIGHT=405.0;

-DEFAULTH &WF_STYLE_WIDTH=770.0;

-DEFAULTH &WF_TITLE=WebFOCUS Report;

GRAPH FILE ibisamp/ggsales

-* Created by Info Assist for Graph

SUM SALES

BY GGSALES.SALES01.CATEGORY

BY YEAR

BY MONTH

WHERE GGSALES.SALES01.DATE FROM 19960101 TO 20001201;

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 LINE

ON GRAPH SET AUTOFIT ON

ON GRAPH SET STYLE *

*GRAPH_SCRIPT

setPieDepth(0);

setPieTilt(0);

setDepthRadius(0);

setCurveFitEquationDisplay(false);

setPlace(true);

setUseSeriesShapes(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=x-axis, $

TYPE=DATA, COLUMN=N4, BUCKET=y-axis, $

*GRAPH_SCRIPT

setReportParsingErrors(false);

setSelectionEnableMove(false);

setFillColor(getSeries(),new Color(255,0,0));

setTransparentBorderColor(getSeries(), true);

setFillMissingData(2);

*GRAPH_JS_FINAL

pieProperties: {

holeSize: 0%

},

blaProperties: {

seriesLayout: absolute

},

agnosticSettings: {

chartTypeFullName: Line_Absolute

}

*END

ENDSTYLE

END

-RUN

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...