Figure 1: SQL Chart Properties
| Name | Description | |||||||
|---|---|---|---|---|---|---|---|---|
| Custom ID | Item link slug. Optional field.
| |||||||
| Label | Menu label. Mandatory field. | Label | ||||||
| Chart Type |
| |||||||
| Chart Title | Chart Title | to be displayed part of the generated graph. |
Figure 2: SQL Chart Properties - Chart Chart Options
| Name | Description | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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, legend will be shown in the generated graph. | |||||||||||||||
Show Value Label in Chart? | If checked, value label will be shown in the generated graph. | |||||||||||||||
| Width | Width in character.
| |||||||||||||||
| Height | Height | |||||||||||||||
| Colors | ||||||||||||||||
in character.
| ||||||||||||||||
| Colors | Series color. Optional field. Comma separated values (CSV) of color codes. Example:
|
Figure 3: SQL Chart Properties - SQLSQL
| Name | Description |
|---|---|
SQL Query | SQL Query to produce the dataset required for the graph type.
|
Figure 4: SQL Chart Properties - UI
| Name | Description | |
|---|---|---|
| Custom Header | Custom Header in HTML. | |
| Custom Footer | Custom Footer in HTML. |
Figure 5: SQL Chart Properties - Advanced
| Name | Description |
|---|---|
| Datasource | |
Userview Key Name |