Skip to content

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:

    Configuration -> Databases -> Queries

  2. 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.

  3. Go to the Dashboards UI:

    Configuration -> Dashboards -> Dashboards

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

    • Name => Real-time Event Counts by Severity

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

  6. 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.

  7. 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:

    Configuration -> Databases -> Queries

  2. 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.

  3. Go to the Dashboards UI:

    Configuration -> Dashboards -> Dashboards

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

    • Name => Real-time Event Counts for Pie

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

  6. 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.

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