Panel Chart

The Chart dashboard panel is used for displaying a graphical chart from any data source. Chart types include:

• Area

• Area Spline

• Bar

• Column

• Line

• Pie

• Spline

Data sources can come from database queries or AJAX calls.

Form Fields

• Panel Name - Name of the panel to be displayed in the panel header.

• Title - The title of the chart, centered at the top.

• Subtitle - The subtitle of the chart, center at the top below the title.

• Chart Type - The type of chart from the available list of line, spline, area, area spline, bar, column, pie.

• X-Axis Type - The type of the x-axis can be category for most cases or timeseries when the category is in epoch time.

• Stacking - Whether to show additional series of data stacked on top of the previous series.

• Legend - Whether to show the legend at the bottom of the chart or not.

• Extra Config - Extra HighCharts configuration that will be merged into the final configuration. Refer to the HighCharts documentation for additional details.

• Source - The source of the data for the chart can be Database for an Unified Assurance database query, or AJAX for a local script that processes it's own data and returns JSON.

• Database Query - If "Source" is set to "Database", the existing database query saved in the system.

• AJAX URL - If "Source" is set to "AJAX", the absolute URL path to the script that returns JSON data on the local server.

• Category Field - The field in the JSON response that defines the category on the x-axis.

• Value Field - The field in the JSON response that defines the value on the y-axis.

• Series Field - The field in the JSON response that uniquely identifies the series for the category and value. Only one series can be defined for pie charts.

• Meta Field - The field in the JSON response that allows additional data to be added to the series or point.

• Hide Header - Whether or not the panel header should be shown.

• Width (%) - Limit the panel to a specific percent width of the dashboard, ranging from 10% to 100%.

• Height (px) - Limit the panel to a specific height in pixels.

• Refresh Rate (secs) - The default chart refresh rate in seconds.

Examples

Example 1

Create a query to return real-time event data for a line, area, bar, or column chart.

Steps

1. Go to the Queries UI: From the Configuration menu, select Databases, and then Queries.

See Queries for more information.

1. Click on the Add button, then set the following:

   1. Name => Real-time Event Counts by Severity

   2. Schema => Event

   3. ShardID => 1

   4. User Owner => [Public to All Users In Group]

   5. Group Owner => [Public to All Groups]

   6. Query =>

        SELECT ELT(Severity + 1, 'Normal', 'Unknown', 'Info', 'Minor', 'Major', 'Critical')                                                                                      AS Severity, 
               ELT(Severity + 1, '{"color":"\#66E066"}', '{"color":"\#D088F4"}', '{"color":"\#A1D3FE"}', '{"color":"\#FEFE66"}', '{"color":"\#FED07E"}', '{"color":"\#FE6666"}') AS Meta,
               DAYNAME(FROM_UNIXTIME(FirstReported))                                                                                                                             AS Day, 
               SUM(Count)                                                                                                                                                        AS Count 
          FROM Events
      GROUP BY Severity,
               DAYNAME(FROM_UNIXTIME(FirstReported)) 
      ORDER BY Severity,
               DAYOFWEEK(FROM_UNIXTIME(FirstReported))
      

   7. Click "Submit" to save the query.

2. Go to the Dashboards UI: From the Configuration menu, select Dashboards, and then Dashboards.

See Dashboards for more information.

1. Click on the Add button, then set the following:

   • Name => Real-time Event Counts by Severity

2. Add a "dashboard -> Chart" panel to the dashboard.

3. Click the "Configure Panel" button, then set the following:

   • Panel Name => Real-time Event Counts by Severity

   • Database Query => Real-time Event Counts by Severity

   • Category Field => Day

   • Value Field => Count

   • Series Field => Severity

   • Meta Field => Meta

   • Click on the "View" button.

4. Click "Submit" button to save the dashboard.

Example 2

Create a query to return real-time event data for a pie chart.

Steps

1. Go to the Queries UI: From the Configuration menu, select Databases, and then Queries.

See Queries for more information.

1. Click on the Add button, then set the following:

   1. Name => Real-time Event Counts for Pie

   2. Schema => Event

   3. ShardID => 1

   4. User Owner => [Public to All Users In Group]

   5. Group Owner => [Public to All Groups]

   6. Query =>

      SELECT DAYNAME(FROM_UNIXTIME(LastReported)) AS Day,
             'Alarm Count'                        AS Name,
             SUM(Count)                           AS Count
        FROM Events
      

   7. Click "Submit" to save the query.

2. Go to the Dashboards UI: From the Configuration menu, select Dashboards, and then Dashboards.

See Dashboards for more information.

1. Click on the Add button, then set the following:

   • Name => Real-time Event Counts for Pie

2. Add a "dashboard -> Chart" panel to the dashboard.

3. Click the "Configure Panel" button, then set the following:

   • Panel Name => Real-time Event Counts for Pie

   • Chart Type => Pie

   • Database Query => Real-time Event Counts for Pie

   • Category Field => Day

   • Value Field => Count

   • Meta Field => Meta

   • Click on the "View" button.

4. Click "Submit" button to save the dashboard.

---

Title and Copyright Information

User’s Guide

G18220-01

Copyright © 2025, Oracle and/or its affiliates.