apex_add_combo_chart
Add a combo chart (bar + line) to an Oracle APEX page. Specify SQL for bar and line series to visualize both metrics on shared axes.
Instructions
Add a combo chart (bar + line on same axes). SQL: LABEL, BAR_VALUE, LINE_VALUE.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| height | No | Chart height in pixels. | |
| labels | No | Optional dict to override labels. Supported keys: ``"bar"`` (bar legend), ``"line"`` (line legend). | |
| bar_sql | Yes | SQL for the bar series. Must return bar_label_col and bar_value_col. Example: "SELECT TO_CHAR(DT_AVALIACAO,'MM/YYYY') LABEL, COUNT(*) VALUE FROM TEA_AVALIACOES GROUP BY TO_CHAR(DT_AVALIACAO,'MM/YYYY') ORDER BY 1" | |
| page_id | Yes | Target page ID. | |
| bar_name | No | Legend name for bar series. | Volume |
| line_sql | Yes | SQL for the line series. Must return line_label_col and line_value_col. Example: "SELECT TO_CHAR(DT_AVALIACAO,'MM/YYYY') LABEL, ROUND(AVG(NR_PCT_TOTAL),1) VALUE FROM TEA_AVALIACOES WHERE NR_PCT_TOTAL > 0 GROUP BY TO_CHAR(DT_AVALIACAO,'MM/YYYY') ORDER BY 1" | |
| sequence | No | Display order on page. | |
| animation | No | Animation style — "auto", "none", "fade", or "zoom". | auto |
| line_name | No | Legend name for line series. | Trend |
| region_name | Yes | Region display name. | |
| y_axis_title | No | Left Y-axis (bar) label. | |
| zoom_enabled | No | Enable zoom on chart axes (default False). | |
| bar_label_col | No | X-axis column in bar_sql (default "LABEL"). | LABEL |
| bar_value_col | No | Y1-axis column in bar_sql (default "VALUE"). | VALUE |
| color_palette | No | List of hex colours, a named palette string, or None. | |
| y2_axis_title | No | Right Y-axis (line) label. | |
| line_label_col | No | X-axis column in line_sql (default "LABEL"). | LABEL |
| line_value_col | No | Y2-axis column in line_sql (default "VALUE"). | VALUE |
| scroll_enabled | No | Enable scroll on chart (default False). |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |