Update/change thresholds based on a second value

Grafana Gauge Panel
1
  • What Grafana version and what operating system are you using?

Grafana v13.0.0 & Debian 13

  • What are you trying to achieve?

I am trying to visualize my cable internet Docsis Chanels with Gauge.

  • How are you trying to achieve it?

InfluxDBv2 + Flux + Gauge + Threshold

  • What happened?

I actually got a simple version of this working. I can query the database, get the values and display them in the Gauge. The threshold is working too. See:

gaugepowerlevel
gaugepowerlevel858×557 35.4 KB

But this is where my headaches start: The thresholds have to be updated/changed based on a second value (called QAM) because the interpretation of the power level changes based on this value. So I kind of need to update the thresholds dynamicly but I have no clue how to achieve this. I tried a lot of different things, but I got no result. Can someone guide me?

2

That looks like a task for transformation Config from query results

3

I got it working on my own yesterday with this transformation that you posted. I had to write a second query that combined sql and flux in order to archive what I wanted. But now it is looking totally awesome!