apex_add_bubble_chart
Add a bubble chart to an Oracle APEX page using a SQL query to define X, Y, bubble size, and optional labels.
Instructions
Add a bubble chart. SQL: X_VALUE, Y_VALUE, BUBBLE_SIZE, optional LABEL.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| height | No | Chart height in pixels. | |
| labels | No | Optional dict to override labels. Supported key: ``"series"`` (series legend label). | |
| page_id | Yes | Target page ID. | |
| sequence | No | Display order on page. | |
| x_column | No | Column for X-axis position. | X |
| y_column | No | Column for Y-axis position. | Y |
| z_column | No | Column for bubble size (larger = bigger bubble). | Z |
| animation | No | Animation style — "auto", "none", "fade", or "zoom". | auto |
| sql_query | Yes | SQL returning label, x, y, and z columns. Example: "SELECT DS_NOME LABEL, COUNT(DISTINCT a.ID_AVALIACAO) X, ROUND(AVG(a.NR_PCT_TOTAL),1) Y, COUNT(DISTINCT a.ID_BENEFICIARIO) Z FROM TEA_TERAPEUTAS t JOIN TEA_AVALIACOES a USING(ID_TERAPEUTA) GROUP BY DS_NOME" | |
| region_name | Yes | Region display name. | |
| series_name | No | Legend series name. | Bubbles |
| label_column | No | Column for tooltip/legend labels. | LABEL |
| x_axis_title | No | X-axis label. | |
| y_axis_title | No | Y-axis label. | |
| zoom_enabled | No | Enable zoom on chart axes (default False). | |
| color_palette | No | List of hex colours, a named palette string, or None. | |
| scroll_enabled | No | Enable scroll on chart (default False). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |