1. Using Guide for Oracle Cloud
  2. Development
  3. The Charts and Dashboards Page
  4. Creating or Editing a Chart

Creating or Editing a Chart

You can create or edit a chart to visualize data using SQL commands.

To create a new chart, click Create Chart.

To edit a chart, click the context menu icon and select Edit.

Enter the following details:

  1. Name: Enter a name for the chart.
  2. Description: Enter a description for the chart.
  3. Protected by Privilege: Select an available privilege from the drop-down list to enable only those with this privilege to securely access the chart.
  4. Published: When enabled, you can share and access the chart externally.

    Note:

    You can also protect a chart by protecting the corresponding module using the REST pages. For more information, see Editing a Resource Module. When a chart is protected, a user must authenticate before viewing the chart.
  5. Click Next.
  6. Enter the SQL statement in the command editor on the left. Ensure that you do not end the SQL statement with a semicolon.
    The chart settings are automatically updated in the Chart Definition section on the right.
  7. Edit/Update the chart settings in the Chart Definition section. The fields in the mapping section varies according to the Chart Type selected.
    When the Chart Type selected is one of the following: Area Chart, Bar Chart, Line Chart, or Line with Area Chart, the mappings displayed are as follows:
    • Orientation: Choose between horizontal and vertical orientation types from the drop-down list.
    • X axis label and Y axis label: Optionally enter labels for X axis and Y axis.
    • Label: The label is auto-generated from the SQL statement which represents the X axis.
    • Value: The Value is auto-generated from the SQL statement which represents the Y axis (the values to be plotted on the chart).
    • Refresh Columns: Refresh the data of all the columns selected in the SQL statement.
    • Coordinate System: Choose between Cartesian and Polar coordinate systems from the drop-down list.
    • Sorting: Choose a sorting type (ascending, descending, off) for plotting the values. If selected, the Sorting value overrides the order specified by the ORDER BY clause in the SQL statement. For a large amount of data, Oracle recommends using the ORDER BY clause to sort data.
    When the Chart Type selected is one of the following: Pie Chart, Pyramid Chart, or Funnel Chart, the mappings displayed are as follows:
    • Style: Select from either 2D or 3D styles.
    • Series ID: The Series ID is auto-generated from the SQL statement which represents the category to be plotted.
    • Value: The Value is auto-generated from the SQL statement which represents the values to be plotted for each category.

    Preview/Auto-preview: Click preview to view the changes made to the chart. If Auto-preview is checked, the changes to the chart are refreshed automatically.

  8. The Chart tab at the bottom displays the chart.
  9. The Data tab at the bottom displays the data resulting from the SQL command.
  10. Click Create to create the chart, or click Save when editing the chart.

    Note:

    Due to browser resource restrictions, the preview of charts is limited to 3000 rows from your SQL query results. However, once you create a chart, all the data is rendered in the standalone view.