- Multi-Series Stacked
Multi-Series Stacked Charts
This tutorial will show how to create a multi-series stacked bar 2D graph via the following set of 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, column3 FROM schema.table
Column 1 is the source of each group of data nodes
Column 2 assigns the nodes within each group
Column 3 is the source of the values of single data node
Under the Display » Properties field, remove all existing code and insert the following code:
Fusion { debugMode:0; type:StackedBar3D; width:800; height:1000; 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, StackedBar2D) may be changed to reflect the wanted graph type
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 multi-series stacked charts include: StackedColumn2D, StackedColumn3D, StackedArea2D, StackedBar2D, StackedBar3D, and MSStackedColumn2D.