apex_add_funnel
Add a funnel chart to an Oracle APEX page. Provide a SQL query with LABEL and VALUE columns, ordered from largest to smallest stage, to visualize stage progression.
Instructions
Add a funnel chart. SQL must alias LABEL + VALUE ordered by sequence.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| height | No | Chart height in pixels (default 380). | |
| page_id | Yes | Target page ID. | |
| sequence | No | Region display order. | |
| sql_query | Yes | SQL ordered from largest to smallest stage. Example: "SELECT DS_STATUS AS LABEL, COUNT(*) AS VALUE FROM TEA_AVALIACOES GROUP BY DS_STATUS ORDER BY 2 DESC" | |
| region_name | Yes | Region title. | |
| series_name | No | Legend label. | |
| label_column | No | Column for stage labels (default "LABEL"). | LABEL |
| value_column | No | Column for stage values (default "VALUE"). | VALUE |
| color_palette | No | Optional hex color list per stage. Note: color_palette is accepted for future compatibility but not applied in APEX 24.2.13. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |