apex_generate_analytics_page
Create an Oracle APEX analytics dashboard page with metric cards and multiple JET charts in a single call. Specify metrics, charts, and page details to build a complete analytics view.
Instructions
Generate a full analytics page with metric cards + multiple JET charts in one call.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| charts | No | List of chart dicts. Each supports the same args as apex_add_jet_chart: - "region_name": Chart title (required) - "chart_type": "bar" | "line" | "area" | "pie" | "donut" (default "bar") - "sql_query": SQL for data (required) - "label_column": Label column name (default "LABEL") - "value_column": Value column name (default "VALUE") - "series_name": Legend label - "height": Chart height px (default 400) - "y_axis_title": Y axis label - "x_axis_title": X axis label - "extra_series": Additional series (for multi-series charts) Example: [ {"region_name": "Avaliações por Status", "chart_type": "pie", "sql_query": "SELECT DS_STATUS LABEL, COUNT(*) VALUE FROM TEA_AVALIACOES GROUP BY DS_STATUS"}, {"region_name": "Evolução Mensal", "chart_type": "line", "sql_query": "SELECT TO_CHAR(DT_AVALIACAO,'MM/YYYY') LABEL, COUNT(*) VALUE FROM TEA_AVALIACOES GROUP BY TO_CHAR(DT_AVALIACAO,'MM/YYYY') ORDER BY 1", "series_name": "Avaliações"}, ] | |
| metrics | No | List of metric card dicts (see apex_add_metric_cards for format). Example: [{"label": "Total", "sql": "SELECT COUNT(*) FROM MY_TABLE", "icon": "fa-database", "color": "blue"}] | |
| page_id | Yes | Target page ID. | |
| page_name | No | Page display name (used only if page is created). | Analytics |
| auth_scheme | No | Authorization scheme name to restrict access (optional). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |