Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
...
Name | Description | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Datasource | Select the datasource for the chart.
| |||||||||||||||
SQL Query | When Datasource is set to "Default Datasource" or "Custom Datasource", this option will show up. You use an SQL Query to produce the dataset required for the graph type. The first column in the dataset will be assumed for the X-axis/label. Example 1:The first column to be returned from the query must be a label (X-axis), followed by value columns for the Y-axis.
Example 2:
| |||||||||||||||
Data Store | When Datasource is set to "Load Data From", this option will show up. Advance Form Data Binder has more flexible ways to build chart datasets using join, group, and aggregate functions. Please see Datalist Binder for the available binders to use. | |||||||||||||||
Configure Database | This option is available when the Datasource is set to "Custom Datasource" (Figure 2a).
| |||||||||||||||
Using List |
|
...
Name | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Order By | Column to be sorted in the graph dataset. This would affect how the graph is plotted. | ||||||||||
Order |
| ||||||||||
X-axis Value | X-axis label. | ||||||||||
Y-axis Values | Y-axis dataset.
|
Figure 4: Chart Options
...
Name | Description | |||||
---|---|---|---|---|---|---|
Echart Theme | This option appears when Echart Library is selected in Configure Chart (Fig 1). | |||||
X-axis Label | X-axis Label | |||||
X-axis display as |
| |||||
Y-axis Label | Y-axis Label | |||||
Y-axis Prefix | Y-axis Prefix | |||||
Show Legend? | If checked, the legend will be shown in the generated graph. | |||||
Show Value Label in Chart? | If checked, the value label will be shown in the generated graph. | |||||
Stack Series? | If checked, this will affect the generated graph. | |||||
Display as Horizontal Chart? | Display as Horizontal Chart. | If checked, the Chart will be displayed horizontally. | ||||
No Boundary Gap | If checked, there will be no gap between the axes label and the chart. | |||||
Width | Width in character, for example 100%. | |||||
Height | Height in character, example 300px. | |||||
ColorsColours | Series colorcolour. Optional field. This option only appears when jqPlots Library is selected in Configure Chart. Comma-separated values (CSV) of color codes. Example 1: #3333FF,#66FF00,#FF9933,#990000
|
...
Figure 5: Advanced Properties
Name | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Series Customization |
| ||||||||||
Additional Customization | This field allows you to insert an additional script that can modify the graph's visualization. (e.g: modify legend position) | ||||||||||
UI Key Name | When defined, the additional conditions will be appended using the value defined here as the parameter and the userview UI key value as the value.
When UI key value is defined, you may define #userviewKey# in your SQL query to have it replaced with the UI key value.
| ||||||||||
Custom Header | Custom Header in HTML. | ||||||||||
Custom Footer | Custom Footer in HTML. |
Figure 6: Chart Properties - Performance & Offline Settings
...