Single Series Charts
This tutorial will show how to create a basic single series pie 2D graph via the following steps:
Create a new SQL operation
In the Advanced » JSP File field, input:
See Figure 1
/wow/fusion/jsp/fusionChart.jsp
:
In the Basic » Operation Code field, create an SQL operation similar to the format: SELECT column1, column2 FROM schema.table
Column 1 will be the string that will be used for the legend
Column 2 must be a numeric value that will be used for graphing
Under the Display » Properties field, remove all existing code and insert the following code:
Fusion { debugMode:0; type:Pie2D; width:600; height:400; script:<chart caption='WOW Fusion' subCaption='WOW POWER' outCnvbaseFontSize='18' bgColor='C0C0C0' xAxisName='Items' yAxisName='Revenue' showValues='0' animation='1' showBorder='0' borderThickness='0' numberPrefix='$' chartTopMargin='1'>??WOW_DATA </chart> ;}
See Figure 2
The type value (in this case, Pie2D) may be changed to reflect the wanted graph type. Refer to the different types of charts.
The width and height values may be changed to adjust the dimensions of the chart
Chart section properties may be edited for more customization
Insert the operation and run
Types of single series charts include: Column2D, Column3D, Pie3D, Pie2D, Line, Bar2D, Area2D, Doughnut2D, and Doughnut3D.