Focal Point
[CLOSED] HTML5 JSCHART - Parabox with Categorical Vertical Axes - Error Obtained.

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7537038676

June 19, 2015, 11:00 AM
David Briars
[CLOSED] HTML5 JSCHART - Parabox with Categorical Vertical Axes - Error Obtained.
The following code...
-*
-* Create relationship data.
-*
DEFINE FILE GGSALES
LEVEL1/A1 = 'A';
LEVEL2/A1 = DECODE SEQ_NO (1 'B'
                           2 'B'
   		         3 'C'
			4 'C');
LEVEL3/A1 = DECODE SEQ_NO (1 'D'
                           2 'E'
			3 'F'
			4 'G');
END
TABLE FILE GGSALES
PRINT
      LEVEL1
      LEVEL2
	  LEVEL3
BY    SEQ_NO
IF    SEQ_NO LE 4
ON TABLE HOLD AS HLDDATA
END
-RUN
-*
-* Visualize relationship data.
-*
GRAPH FILE HLDDATA
PRINT LEVEL1
      LEVEL2
      LEVEL3
BY    SEQ_NO
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH PARABOX
ON GRAPH SET AUTOFIT ON
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/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT='WebFOCUS Report', $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
*END
ENDSTYLE
END 

...gives me the following error message:
0 NUMBER OF RECORDS IN TABLE=        4  LINES=      4
0 NUMBER OF RECORDS IN GRAPH=        4  PLOT POINTS=      4
VERTICAL AXIS IS NOT NUMERIC..CAN'T GRAPH   

My requirement is to provide a visualization of 'relationship' data.

Per the 'Creating HTML5 Charts with the WebFOCUS Language' manual, I should be able to create a parabox chart with categorical vertical axes.

However my attempt is giving an error message, seemingly contradicting my plan/hope. :-)

It is almost as if there is an override that I need to provide to allow alphanumeric axes. ?

The graph was orginally created with WFDS IA. I couldn't find a way in IA to create alphanumeric axes.

This message has been edited. Last edited by: <Kathryn Henning>,




Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster
June 19, 2015, 11:10 AM
eric.woerle
David,

Which version of the HTML 5 charts document do you have? I find that the 8.1.03 document is much more complete then the 8.0.08.


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
June 19, 2015, 11:56 AM
David Briars
Thanks for the suggestion, Eric. It looks like the 8.1 manual echoes the 8.0 manual in terms of this schenario...mention of the support for categorical axes (joy), but no description/example on how to do it (sadness).

If someone has an idea, I'd be appreciative.




Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster