search

snuids / grafana-radar-panel

A radar graph panel for Grafana
MIT License
24 stars 12 forks source link

Need basic help building query for MySQL connector #12

Open utsecnet opened 5 years ago

utsecnet commented 5 years ago

I have a very simple MySQL database table that looks like:

+----+-------------------------+-------+---------+---------+
| id | program_name            | value | goal_1y | goal_6m |
+----+-------------------------+-------+---------+---------+
|  1 | vulerability management |     2 |       5 |       3 |
|  2 | incident response       |     2 |       4 |       2 |
|  3 | infrastructure          |     4 |       8 |       6 |
|  4 | data ecurity            |     2 |       7 |       5 |
|  5 | cloud security          |     3 |       6 |       4 |
|  6 | IDM                     |     4 |       7 |       6 |
+----+-------------------------+-------+---------+---------+

I know MySQL isn't officially supported, but I've seen the author of this plugin help others that are using it for MySQL. I am trying to get one blob for Value, one blob for goal_1y, and one blob for goal_6m. I don't know how to build the query to get the display like I want. Can someone help me?