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
-
Go to the Queries UI:
-
Click on the Add button, then set the following:
-
Name => Real-time Event Counts by Severity
-
Schema => Event
-
ShardID => 1
-
User Owner => [Public to All Users In Group]
-
Group Owner => [Public to All Groups]
-
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))
-
Click "Submit" to save the query.
-
-
Go to the Dashboards UI:
-
Click on the Add button, then set the following:
- Name => Real-time Event Counts by Severity
-
Add a "dashboard -> Chart" panel to the dashboard.
-
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.
-
-
Click "Submit" button to save the dashboard.
Example 2
Create a query to return real-time event data for a pie chart.
Steps
-
Go to the Queries UI:
-
Click on the Add button, then set the following:
-
Name => Real-time Event Counts for Pie
-
Schema => Event
-
ShardID => 1
-
User Owner => [Public to All Users In Group]
-
Group Owner => [Public to All Groups]
-
Query =>
SELECT DAYNAME(FROM_UNIXTIME(LastReported)) AS Day, 'Alarm Count' AS Name, SUM(Count) AS Count FROM Events
-
Click "Submit" to save the query.
-
-
Go to the Dashboards UI:
-
Click on the Add button, then set the following:
- Name => Real-time Event Counts for Pie
-
Add a "dashboard -> Chart" panel to the dashboard.
-
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.
-
-
Click "Submit" button to save the dashboard.