5 Visualizing and Analyzing Data

Oracle APEX's native region components simplify visualizing and analyzing data.

After choosing the region type that fits your requirements, configure the data it should use and adjust its settings in the Property Editor to fine-tune look and behavior. Consider installing the Sample Reports app from the Gallery to study additional useful examples that employ the different kinds of regions described in this section.

Using the Refresh dynamic action, you can refresh any of the regions in response to a user action to show updated data.

Tip:

Sometimes your region's WHERE clause or SQL query references page item values as bind variables, for example :P1_SAL < :P1_COMM. Regardless of the region type, always make sure to list the names of these page items like P1_SAL,P1_COMM in the region's Page Items to Submit property. This ensures APEX refreshes the data using the latest values the end user set in the page. Failure to do so leaves their values null. This can inadvertently cause a query to return no data.

  • Listing Data with Classic Reports
    The Classic Report region displays data in a table, with optional pagination.
  • Personalizable Interactive Reports
    The Interactive Report region is a tabular display that lets users filter, sort, highlight, format, compute, aggregate, group, pivot, chart, download, and email the data you configure it to work with.
  • Flexibly Styling and Acting on Data
    The Content Row region lets you flexibly style each row of data.
  • Info Tiles Using Cards
    To show results as information tiles, use a Cards region.
  • Info at a Glance with Charts & Dashboards
    Use a Chart region to present data visually using one of 18 different styles. You can add multiple charts on a page to create a dashboard. Most chart types can show multiple series of data.
  • Showing Data on Maps
    Use a Map region to display data related to specific locations or areas on the earth. One map can show multiple layers when needed. For each layer you configure a table, SQL query, or other data source, and choose a layer type.
  • Placing Events on a Calendar
    Use a Calendar region to display scheduled events with a month, week, day, or list view.
  • Exploring Hierarchical Data in a Tree
    Use the Tree region to show hierarchical data like the management chain of employees in the EMP table. APEX can manage the hierarchy so you only need to configure the data to display in each tree node.
  • Dynamically Formatting Data
    When none of APEX's other region types meet your requirements, the Dynamic Content region lets you programmatically generate all its HTML markup. Your code constructs a CLOB containing any mix of tags and data and returns it for the APEX engine to include in the appropriate place in the page.