Multiple gauge with dynamic max value

Grafana Dashboards
1

Using MySQL datasource, I have this data:

+--------+-------+-----+
| class  | value | max |
+--------+-------+-----+
| classA |     7 |  10 |
| classB |     6 |  13 |
| classC |     4 |   4 |
| classD |     3 |   7 |
+--------+-------+-----+

Using Gauge, how can I have the max column as the max of each gauge ?

I managed to set the maximum value of max as the max of all the gauge using Config from query results transformation. But what I want is that each gauge should have its own max.

I want something similar to this: (source from Grafana Play)

grafana-play
grafana-play1577×269 33.3 KB

… with each gauge having its own max.

Thanks!

2

If you want to have different threshold for each dimension, you can try use another datasource query (for example testdata’s csv). The difficulty is to join the results in Math expression. To do that you need dimensions on both sides to have the same labels. Look around the forum, there should be an example of this.