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

[Guest]

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

[Douglas Lee 2]

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

[Warren Hinchliffe]

That will do it.

I think the charts automatically remove Missing values.

[Martin Yergeau]

Douglas,

Your issue was that youve assigned a value MISSING and not the WebFOCUS equivalent NULL value MISSING, such as David point out.

[Douglas Lee 2]

The addition of MISSING ON works nicely when added to a DEFINE in TEXT, but, hows that added in IA

 

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

Unfortunately, the charts DONT automatically remove Missing values

[Manoj Chaurasia]

Hi Doug

In InfoAssist you can set MISSING ON with a DEFINE

 

image.png701403 22.9 KB

[Douglas Lee 2]

That worked ~ No surprise there, right! . I edited the DEFINE a bit for emphasis: