Definition

Chart allows you to select a form data store or define your own SQL query to display data for the most common graph types.

Figure 1: Chart Properties

NameDescription

Chart Type

  • Area Chart
  • Bar Chart
  • Bubble Chart
  • Candlestick Chart
  • Donut Chart
  • Open High Low Close Chart (OHLC Chart) 
  • Pie Chart
  • XY Chart
Chart TitleChart Title to be displayed as part of the generated graph.
Data Store

See List Data Store for available data store to use.


Figure 2: Chart Properties - Data Store & 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

The date format of date value data retrieved from data store.


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, the 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