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.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"page_id": "<page_id>",
"region_name": "<region_name>",
"sql_query": "<sql_query>"
},
"name": "apex_add_funnel"
}
}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 |