apex_add_pareto_chart
Add a Pareto chart with bars and cumulative % line to an Oracle APEX page via SQL returning label and value columns.
Instructions
Add a Pareto chart (bars + cumulative % line). SQL: LABEL, VALUE.
Input 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), ``"y2_axis"`` (right Y-axis title). | |
| page_id | Yes | Target page ID. | |
| bar_name | No | Legend name for the bar series. | Count |
| sequence | No | Display order on page. | |
| animation | No | Animation style — "auto", "none", "fade", or "zoom". | auto |
| line_name | No | Legend name for the cumulative % line. | Cumulative % |
| sql_query | Yes | SQL returning label and value columns, ordered DESC. Example: "SELECT DS_STATUS LABEL, COUNT(*) VALUE FROM TEA_AVALIACOES GROUP BY DS_STATUS ORDER BY 2 DESC" | |
| region_name | Yes | Region display name. | |
| label_column | No | Column name for categories (default "LABEL"). | LABEL |
| value_column | No | Column name for numeric values (default "VALUE"). | VALUE |
| zoom_enabled | No | Enable zoom on chart axes (default False). | |
| color_palette | No | List of hex colours, a named palette string, or None for default colours. | |
| cumulative_sql | No | Custom SQL for the cumulative % line. Must return the same label column and a ``VALUE`` column. When ``None``, the cumulative SQL is auto-generated from *sql_query*. | |
| scroll_enabled | No | Enable scroll on chart (default False). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |