Grafana: Difference between revisions

From Leo's Notes
This page was last edited on 14 January 2021, at 16:51.
mNo edit summary
Line 1: Line 1:
Grafana is a tool to generate graphs and dashboards.  
Grafana is a tool to generate graphs and dashboards.  


== Random Notes ==
==Random Notes==


===Pie Graph using MySQL===
===Pie Graph using MySQL===
Line 17: Line 17:
}}
}}


=== Ordering Series ===
=== Custom Colors in Pie Graph ===
Specify custom colors for each series by editing the JSON data directly. There should be an <code>aliasColors</code> field which needs to be populated. For example:
{{Highlight
| code = "aliasColors": {
    "1 min to 10 min": "#3b7dd0",
    "1 to 5 hours": "#e8cb2a",
    "10 min to 1 hour": "#73bf69",
    "5 to 24 hours": "#e8912a",
    "Over 24 hours": "#b21c1c",
    "Under 1 min": "#5fc5ff"
  },
| lang = json
}}
 
===Ordering Series===
When making a line graph, I wanted to order series in a specific order. The best way I found was to just have multiple queries selecting specific series in a particular order.
When making a line graph, I wanted to order series in a specific order. The best way I found was to just have multiple queries selecting specific series in a particular order.

Revision as of 16:51, 14 January 2021

Grafana is a tool to generate graphs and dashboards.

Random Notes

Pie Graph using MySQL

With the following query, I am able to generate a two column result set which I want to put into a pie graph.

SELECT requested_cpu, COUNT(requested_cpu) FROM `jobs` GROUP BY requested_cpu ORDER BY `COUNT(requested_cpu)` DESC

However, the Grafana Pie Graph plugin requires the result to be a time series. To work around this, add the timeseries with the current timestamp and ensure that the metric is a char type.

SELECT now() as time_sec, COUNT(requested_cpu) as `value`, CONVERT(requested_cpu, char) as metric 
FROM `jobs` WHERE   $__timeFilter(started) 
GROUP BY requested_cpu

Custom Colors in Pie Graph

Specify custom colors for each series by editing the JSON data directly. There should be an aliasColors field which needs to be populated. For example:

"aliasColors": {
    "1 min to 10 min": "#3b7dd0",
    "1 to 5 hours": "#e8cb2a",
    "10 min to 1 hour": "#73bf69",
    "5 to 24 hours": "#e8912a",
    "Over 24 hours": "#b21c1c",
    "Under 1 min": "#5fc5ff"
  },

Ordering Series

When making a line graph, I wanted to order series in a specific order. The best way I found was to just have multiple queries selecting specific series in a particular order.