Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
borderColorgreen
borderWidth1
titleBGColor#ddffcc
borderStylesolid
titleDefinition

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.

Code Block
titleExample
640px
Height (px)

Height in character.

Code Block
titleExample
480px
Colors

Series color. Optional field.

Comma separated values (CSV) of color codes.

Example:

Code Block
titleExample
 #3333FF,#66FF00,#FF9933,#990000

Image Modified

Code Block
titleExample
red,orange,yellow,green,blue,indigo

Image Modified

Info
titleWhat are the default colors?

http://stackoverflow.com/questions/18332440/what-are-the-jqplot-default-series-colors

Alignment
  • Left
  • Center
  • Right
Margin Bottom

Bottom Margin of Chart 

Info
titleExample

10px