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

[Martin Yergeau]

You mean instead of producing a graph, have a tabular report

Change the output format from graph to tabular report or data grid

[Ben Maxwell]

There was something I saw in a Webinar where someone ran a graph, and clicked a button in the bottom-right hand corner which showed the data behind the scenes. Just not quite sure how they did it.

[Martin Yergeau]

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.

[Ben Maxwell]

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

[Martin Yergeau]

Close everything and try back

Look at the code behind

[Ben Maxwell]

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

[Martin Yergeau]

Why are you having a AHTML compound report with two reports :

1- tabular (refer to Cache_1) and you have WHERE clauses at that step And it is hidden within the compound report

2- graph (refer to TableChart_1)

Is that what youve done

You should start from fresh

[Ben Maxwell]

Im working in InfoAssist (WF 8207.27), and I thought I saw in some Webinar that there was some way to view the data behind the chart

 

image.png959589 13.2 KB

 

Any idea if anyone knows how you can toggle between graph and data

[Ben Maxwell]

My exact steps for this one were

App Studio --> New --> InfoAssist --> Visualization

 

Selected Car master file

 

Clicked and dragged SALES into Vertical Axis, and COUNTRY into Horizontal Axis

 

Then when I run the chart and then view the data I see this

[Manoj Chaurasia]

Benjamin

I get the same results with 8.2.07.27, you need to open a case with techsupport and report this issue

[David Beagan]

I get the expected correct result in 8207.04. So it does appear that this is something to be reported to TechSupport.