Joget DX Beta Available for Download

Check out Joget DX, the next generation successor to Joget Workflow for faster, simpler digital transformation.

Skip to end of metadata
Go to start of metadata
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
  • Open High Low Close Chart (OHLC Chart) 
  • Pie Chart
  • XY Chart
Chart TitleChart Title to be displayed as 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 the 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

Date Data Format


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