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

Im working in InfoAssist (WF 8207.27), and I thought I saw ...


Ben Maxwell

Recommended Posts

I think that weve saw the same Webinar.

When you are in Designer you can change the output format by clicking on the grid format located on the vertical right end ribbon

I cannot remember that it is possible to have this done without changing the output format.

If you Assemble the visualization in a page where you add an output format selection, then you will have it in a single click otherwise I dont think so.

Link to comment
Share on other sites

Ok - I got this to work in App Studio. I had to selection infoassist --> visualization.

Now my next issue, using a simple Cars file I wrote this graph :

 

When I clicked on the data version of this graph I get this :

 

Why would sales appear 3 times in this data

Link to comment
Share on other sites

Here is the code which was generated from this chart. Let me know if you spot anything which would cause the sales to come into the report 3 times. Also I did close and reopen AppStudio, and I still had the replicate data.

 

SET UNITS=PIXELS

ENGINE INT CACHE SET ON

SET WEBVIEWER=ON

SET PAGE-NUM=NOLEAD

SET SQUEEZE=ON

-DEFAULTH &WF_HTMLENCODE=ON;

SET HTMLENCODE=&WF_HTMLENCODE

SET HTMLCSS=ON

SET ARGRAPHENGINE=JSCHART

-DEFAULTH &WF_EMPTYREPORT=ON;

SET EMPTYREPORT=&WF_EMPTYREPORT

SET AROUTPUT=EXTJS

SET EMBEDHEADING=ON

SET GRAPHDEFAULT=OFF

SET ARCACHEMODE=NOEXTRACT

COMPOUND LAYOUT PCHOLD FORMAT AHTML

SECTION=Section_1, LAYOUT=ON, PAGESIZE=E, ORIENTATION=PORTRAIT, SHOW_GLOBALFILTER=OFF, ACTIVE_UNITS=PTS, PAGECOLOR=RGB(255 255 255), ARGRAPHENGINE=JSCHART, $

PAGELAYOUT=1, NAME=Page 1, TEXT=Page 1, LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.25, BOTTOMMARGIN=0.25, $

OBJECT=HBOX, NAME=HBox_1, CONTENT=TableChart_1, POSITION=(0.0 0.0), DIMENSION=(100.0% 100.0%),$

COMPONENT=Cache_1, COMPONENT-TYPE=REPORT, POSITION=(1.0 1.0), DIMENSION=(3.0 4.0), HIDDEN=ON, ARFILTER_TARGET=, METADATA=VERSION:1.0, $

COMPONENT=TableChart_1, COMPONENT-TYPE=GRAPH, POSITION=(0.0 0.0), DIMENSION=(100.0% 100.0%), ARREPORTSIZE=DIMENSION, ARGRAPHENGINE=JSCHART , ARFILTER_TARGET=, METADATA=VERSION:1.0, $

END

SET COMPONENT=Cache_1

-*component_type report

SET ARVERSION=1

-DEFAULTH &WF_TITLE=WebFOCUS Report;

TABLE FILE ibisamp/car

PRINT CAR.ORIGIN.COUNTRY

WHERE RECORDLIMIT EQ 1;

WHERE READLIMIT EQ 1;

HEADING

 

ON GRAPH PCHOLD FORMAT AHTML

ON TABLE NOTOTAL

ON TABLE SET PREVIEW ON

ON TABLE SET ARCACHEMODE NOEXTRACT

ON TABLE SET WEBVIEWER ON

ON TABLE SET STYLE *

TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, HIDDEN=ON, PAGESIZE=E, AR_SHOW_MENUBAR=POPOUT, ARCACHEINCLUDE=, ARGRAPHENGINE=JSCHART, $

ENDSTYLE

END

SET COMPONENT=TableChart_1

-component_type graph

SET ARVERSION=1

-DEFAULTH &WF_TITLE=WebFOCUS Report;

GRAPH FILE ibisamp/car

- Created by Info Assist for Graph

SUM CAR.BODY.SALES

BY CAR.ORIGIN.COUNTRY

HEADING

 

ON GRAPH PCHOLD FORMAT AHTML

ON GRAPH SET VZERO OFF

ON GRAPH SET HAXIS 100.0

ON GRAPH SET VAXIS 100.0

ON GRAPH SET UNITS INCHES

ON GRAPH SET LOOKGRAPH BAR

ON GRAPH SET STYLE *

*GRAPH_SCRIPT

setPieDepth(0);

setPieTilt(0);

setDepthRadius(0);

setCurveFitEquationDisplay(false);

setPlace(true);

END

INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENID_Default.sty,$

TYPE=REPORT, TITLETEXT=Bar Stacked1, PAGESIZE=E, AR_SHOW_MENUBAR=POPOUT, ARREPORTSIZE=DIMENSION, ARFILTER_TARGET=, ARGRAPHENGINE=JSCHART, $

TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $

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

*GRAPH_SCRIPT

setReportParsingErrors(false);

setSelectionEnableMove(false);

*GRAPH_JS_FINAL

pieProperties: {

holeSize: 0%

},

blaProperties: {

seriesLayout: stacked

},

agnosticSettings: {

chartTypeFullName: Bar_Stacked

}

*END

ENDSTYLE

END

COMPOUND END

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...