About Creating Charts

You define a chart in Application Builder using a wizard. For most chart wizards, you select a chart type and provide a SQL query using the following syntax:

SELECT link, label, value
FROM   ...

Where:

link is a URL.
label is the text that displays in the bar.
value is the numeric column that defines the bar size.

For example:

SELECT null, ename, sal
FROM   scott.emp
WHERE  deptno = :P101_DEPTNO

To create a dial chart, select a dial chart type and provide a SQL query using the following syntax:

SELECT value , maximum_value [ ,low_value [ ,high_value] ]
FROM   ...

Where:

value is the starting point on the dial.
maximum_value is the possible highest point on the dial.
low_value and high_value are the historical low and high values.

For example:

SELECT dbms_random.value(500, 1200), 1300, dbms_random.value(100, 200)
FROM DUAL

Table: Available Chart Types describes the chart types available in Application Builder.

Available Chart Types

Chart Type	Description
Bar (HTML)	Bar chart showing one data series with each data point represented by a bar. HTML-based. Does not require a plug-in.
Bar, Horizontal	Single series-based bar chart oriented horizontally with each data point in the series represented by a bar. SVG-based. Requires a SVG plug-in.
Bar, Vertical	Single series-based bar chart oriented vertically with each data point in series represented by a bar. SVG-based. Requires a SVG plug-in.
Cluster Bar, Horizontal	Multiple series-based bar chart oriented horizontally and clustered by a common variable with each data point in the series represented by a bar (for example, Department sales total clustered by month of year). SVG-based. Requires a SVG plug-in.
Cluster Bar, Vertical	Multiple series-based bar chart oriented vertically clustered by a common variable with each data point in series represented by a bar (for example, Department sales total clustered by month of year). SVG-based. Requires a SVG plug-in.
Dial - Sweep	Also known as an angular gauge; this chart shows either percentage of maximum value or absolute value compared to a maximum value represented as a solid area. SVG-based. Requires a SVG plug-in.
Dial	Also known as angular gauge; this chart shows either percentage of maximum value or absolute value compared to maximum value represented as a line. SVG-based. Requires a SVG plug-in.
Line	Multiple series-based line chart oriented with each line representing all data points in the series. SVG-based. Requires a SVG plug-in.
Pie	Single series-based pie chart with each slice representing a data point in the series. SVG-based. Requires a SVG plug-in.
Stacked Bar, Horizontal	Multiple series-based bar chart oriented horizontally with each data point being an absolute value in the series representing a segment of a single bar. SVG-based. Requires a SVG plug-in.
Stacked Bar, Vertical	Multiple series-based bar chart oriented vertically with each data point being an absolute value in the series representing a segment of a single bar. SVG-based. Requires a SVG plug-in.
Stacked Percentage Bar, Horizontal	Multiple series-based bar chart oriented horizontally with each data point being an percentage of 100% of the series represented by a segment of a single bar. SVG-based. Requires a SVG plug-in.
Stacked Percentage Bar, Vertical	Multiple series-based bar chart oriented vertically with each data point being an percentage of 100% of the series represented by a segment of a single bar SVG-based. Requires a SVG plug-in.

Note:

Do not change the type of an existing chart. Instead, delete the existing chart and then re-create it.