apex_add_gradient_donut
Add a gradient donut chart with a center label to an Oracle APEX page. Supply SQL for label and value columns, with optional SQL for the center value.
Instructions
Add a gradient donut chart with center label. SQL: LABEL, VALUE.
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. | |
| animation | No | Animation style — "auto", "none", "fade", or "zoom". | auto |
| sql_query | Yes | SQL returning label and value columns. Example: "SELECT DS_STATUS LABEL, COUNT(*) VALUE FROM TEA_AVALIACOES GROUP BY DS_STATUS ORDER BY 1" | |
| region_name | Yes | Region display name. | |
| series_name | No | Legend series name. | Distribution |
| label_column | No | Column for slice labels. | LABEL |
| value_column | No | Column for slice values. | VALUE |
| zoom_enabled | No | Ignored for donut charts (accepts for API consistency). | |
| color_palette | No | List of hex colours, a named palette string, or None. | |
| scroll_enabled | No | Ignored for donut charts (accepts for API consistency). | |
| legend_position | No | "end" | "start" | "top" | "bottom" | "none". | end |
| center_label_sql | No | SQL returning VARCHAR2 for the donut center. Example: "SELECT TO_CHAR(COUNT(*)) FROM TEA_AVALIACOES" | |
| center_label_text | No | Static text for center (fallback if SQL fails). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |