Hello Everyone,

I am currently trying to create a chart in Info Assist which shows the top 15 sales as a bar chart while also using the Animate to show the sales over time using the Invoiced Year. The problem I am having is that the chart does not resort the values after every year. So say over a 10 year period a certain product has the top sales three years out of that Ten, instead of reorganizing the list after every animation, it will have the product listed three times instead of showing where it is during that year. Not sure if Im entering the values incorrectly or if Im trying to do something that currently isnt possible?



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 sales/allsalesinvoicedata
-* Created by Info Assist for Graph
SUM INVOICE_AMOUNT
BY INVOICE_YEAR
BY TOTAL HIGHEST 15 INVOICE_AMOUNT NOPRINT
BY SERIES
WHERE INVOICE_YEAR GE 2012
HEADING
"Top 15 - 2018"
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET AUTOFIT ON
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);
setPlace(true);
setCurveFitEquationDisplay(false);

*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=HEADING, JUSTIFY=CENTER, $
TYPE=HEADING, LINE=1, ITEM=1, OBJECT=TEXT, FONT='Trebuchet MS', SIZE=12, COLOR=RGB(66 70 73), STYLE=BOLD, $
TYPE=DATA, COLUMN=N1, BUCKET=slider, $
TYPE=DATA, COLUMN=N2, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N4, BUCKET=y-axis, $
*GRAPH_SCRIPT

setUseSeriesShapes(true);
setScaleMustIncludeZero(getX1Axis(), false);
setScaleMustIncludeZero(getY1Axis(), false);
setScaleMustIncludeZero(getY2Axis(), false);
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDisplay(getDataText(0), true);
setDataTextDisplay(true);
setDisplay(getLegendArea(),false);
setFrameAutoShade(false);
setAxisSide(getO1Axis(),0);
setExcludeMaxLabel(getO1Label(),false);
setLabelStagger(getO1Label(),false);
setDepthAngle(45);
*GRAPH_JS_FINAL
"pieProperties": {
"holeSize": "0%"
},
"blaProperties": {
"orientation": "horizontal"
},
"agnosticSettings": {
"chartTypeFullName": "Bar_Clustered_Horizontal"
}

*END
ENDSTYLE
END

-RUN

Thanks,
Kyle


Webfocus 8203

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

Klofs

Comment out this line and see if it behaves better for you.

-*TYPE=DATA, COLUMN=N2, BUCKET=x-axis, $

Still the same problem, but now some products are blank on the y-axis but stll show the value

It should have cleared up the multiple entries... You may need to open a case with techsupport on this..