apex_add_percent_bars
Add horizontal percent bars to Oracle APEX pages using a SQL query to define labels and values, enabling clear visual comparison with customizable colors and display options.
Instructions
Add horizontal percent bars. Each: {label, value, max, color}.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| color | No | Bar color (named or hex). | unimed |
| page_id | Yes | Target page ID. | |
| sequence | No | Display order on page. | |
| sql_query | Yes | SQL returning label and numeric value. Example: "SELECT DS_STATUS LABEL, COUNT(*) VALUE FROM TEA_AVALIACOES GROUP BY DS_STATUS ORDER BY 2 DESC" | |
| custom_css | No | ||
| region_name | Yes | Region display name. | |
| show_values | No | Show value number at end of bar (default True). | |
| label_column | No | Column name for the row label. | LABEL |
| value_column | No | Column name for the numeric value. | VALUE |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |