6.3 Example: Creating and Editing a Chart

This section provides an example of creating and editing a chart.

Creating a Chart

The following example shows how to create a chart to understand the cumulative salary earned by each job category.

  1. Navigate to the Charts page from Database Actions homepage.
  2. Click Create Chart.
  3. Enter the details of the chart as follows:
    • Name: Total Salary by Job Category
    • Description: The cumulative salary earned by each job category.
    • Chart Definition:
      • SQL Statement:
        
SELECT SUM(SALARY), JOB_ID
FROM EMPLOYEES
GROUP BY JOB_ID
      • Chart Type: Area Chart
      • Orientation: Vertical
      • X axis label: Job Category
      • Y axis label: Total Salary
      • Label: JOB_ID (VARCHAR2)
      • Value: SUM(SALARY) (NUMBER)
      • Coordinate system: Cartesian
      • Sorting: Off
    • Click Preview in the Mapping section to preview the chart below.Create chart slider window
    • Change the Chart Type to Bar Chart, Sorting to Descending and click Preview to view the updated chart.Create chart slider window
  4. Click Create to create the chart. A confirmation notification is displayed and the chart card is visible in the Charts page.
  5. Click the Selector context menu and select View Chart to view the chart in a new tab. View of the bar chart in a new tab.

Editing a Chart

The following example edits the chart created in the previous section.

  1. Click the Selector context menu and select Edit to edit the chart. Card view of the chart
  2. In the Mapping section, change the Chart Type to Pie Chart and Style to 3D.
  3. Click Preview to view the updated chart.edit chart slider window
  4. Click Save.
  5. Click the Selector context menu and select View Chart to view the updated chart in a new tab. View of the pie chart in a new tab.