Figure 1: SQL Chart Properties
| Name | Description |
|---|---|
| Custom ID | Item link slug. Optional field. Unique field Value defined here must be unique to the rest of the Userview Menus as the first matching name will be called upon. |
| Label | Menu label. Mandatory field. |
| Chart Type |
|
| Chart Title | Chart Title to be displayed part of the generated graph. |
Figure 2: SQL Chart Properties - 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. Example 100% |
| Height | Height in character. Example 300px |
| 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
What are the default colors? |
Figure 3: SQL Chart Properties - SQL
| 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 |