- Single Series Charts

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
1. In the Advanced » JSP File field, input:
  1. See Figure 1

- 1. /wow/fusion/jsp/fusionChart.jsp

- 1. :

1. In the Basic » Operation Code field, create an SQL operation similar to the format: SELECT column1, column2 FROM schema.table
  1. Column 1 will be the string that will be used for the legend
  2. Column 2 must be a numeric value that will be used for graphing
2. Under the Display » Properties field, remove all existing code and insert the following code:

- 1. 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> ;}

- 1. See Figure 2

- 1. The type value (in this case, Pie2D) may be changed to reflect the wanted graph type. Refer to the different types of charts.
  2. The width and height values may be changed to adjust the dimensions of the chart
  3. 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.

Page updated

Report abuse