This tutorial will show how to create a thermometer instrumentation 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 FROM schema.table
Column 1 must be a numeric value or the result of an SQL aggregate function
For Pyramid and Funnel instrumentations, use the format: SELECT column1, column2 FROM schema.table
Under the Display » Properties field, remove all existing code and insert the following code:
Fusion { type:Thermometer; width:200; height:650; script:<chart lowerLimit='0' upperLimit='1500' majorTMNumber='11' majorTMHeight='2' minorTMNumber='9' majorTMThickness='1' decimalPrecision='0' tickMarkDecimalPrecision='0' refreshInterval='0' thmFillColor='FF5904' showValue='1' chartLeftMargin='53' chartRightMargin='37' chartTopMargin='40' chartBottomMargin='40' borderThickness='2'> <value>??WOW_DATA </value></chart> ;}
See Figure 2
The type value (in this case, Thermometer) 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
Custom objects add chart objects and are entirely optional, see documentation on custom objects for more information
Certain instruments may have additional properties (e.g. color range), please see documentation on specific instruments for these additional properties
Insert the operation and run
Types of instrumentations include: AngularGauge, Linear, HorLED, RT_Bulb, Cylinder, Funnel, Pyramid, and Thermometer
NOTE: As of Fusion Charts version 3.2, HorLED, RT_Bulb and Linear have been renamed hled, bulb and HLinearGauge respectively.