You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Definition

Chart allows you to define your own SQL query to determine the charts that you would like to generate, ranging from a number of graph types.


Figure 1: Chart Properties

NameDescription

Chart Type

  • Area Chart
  • Bar Chart
  • Bubble Chart
  • Candlestick Chart
  • Donut Chart
  • Line Chart (is there a reason this is not in Userview Chart?)
  • Open High Low Close Chart (OHLC Chart) this is not in userview chart
  • Pie Chart
  • XY Chart
Chart TitleChart Title to be displayed part of the generated graph.
Data Binder

When Datasource is set to "Using Data Binder", this option will show up.

Please see Datalist Binder for available binder to use.


Figure 2: Chart Properties - Data Binder & Chart Data Mapping

NameDescription

Order By

Column to be sorted in the graph dataset. This would affect how the graph is plotted.
Order
  • ASC
  • DESC
X-axis Value

X-axis label. 

Y-axis ValuesY-axis dataset.
Date Data Format

this is not in userview chart


Figure 3 : Chart Properties - Chart Options

NameDescription

X-axis Label

X-axis Label 

X-axis display as
  • Category
  • Number
  • Date
Y-axis Label

Y-axis Label 

Y-axis PrefixY-axis Prefix
Show Legend?If checked, legend will be shown in the generated graph.
Width (px)

Width in character.

Example
640px
Height (px)

Height in character.

Example
480px
Colors

Series color. Optional field.

Comma separated values (CSV) of color codes.

Example:

Example
 #3333FF,#66FF00,#FF9933,#990000

Example
red,orange,yellow,green,blue,indigo

Alignment
  • Left
  • Center
  • Right
Margin Bottom

Bottom Margin of Chart 

Example

10px

  • No labels