apex_add_comparison_panel
Add a side-by-side comparison panel to an Oracle APEX page, displaying two columns of metrics for direct comparison between two data sets or periods.
Instructions
Add a side-by-side comparison panel (two columns of metrics).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page_id | Yes | Target page ID. | |
| sequence | No | Display order on page. | |
| custom_css | No | Additional CSS rules injected into the style block. | |
| left_color | No | Accent color for left column. | blue |
| left_label | Yes | Header for the left column (e.g., "Periodo Anterior"). | |
| region_name | Yes | Internal region name. | |
| right_color | No | Accent color for right column. | green |
| right_label | Yes | Header for the right column (e.g., "Periodo Atual"). | |
| left_metrics | Yes | Metrics for left column. Each dict: {"label": "Total", "sql": "SELECT COUNT(*) FROM ...", "suffix": ""} | |
| right_metrics | Yes | Metrics for right column (same format as left_metrics). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |