How to get a dynamic threshold in stat panel?

Grafana Stat Panel
1

  • What Grafana version and what operating system are you using?
    v9.2.2 Windows 11

  • What are you trying to achieve?
    Set a threshold as a percentage of one query result out from the result of another query.

  • How are you trying to achieve it?

  • What happened?

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

For example, I’d like to have Number of Slow Calls display in red if its value exceeds from 10% de number of total calls.
image

2

What is your data source?
I would do it with Overrides value mapping

image
image1890×507 113 KB

3

Infinity. As a first step, I’d need to set the thresholds as percentages of other values. Then, I need to retrieve via HTTP request a value to set as threshold. Are these things possible?

4

use jsonata or transformations to get the percentages.

image
image1010×559 26.7 KB

I am not a fan of transformation, I like to do it on the data source itself.

image
image819×222 18.5 KB

5

But… how does this relate to thresholds? I mean… how to utilize the calculated values as thresholds?

6

this is what you want, coloring something. threshold is not the only way to color things. You can also color things using overrides. In the below case notice the value mapping of a range between 10 and 100

image
image1079×453 52.6 KB

7

I’m afraid this is different. It’s not the percentage I want to be colored, but a stat when it exceeds a given percentage.

8

the same principle applies. is it a calculated value or static value? Please provide sample json data coming from your api

9

Given a JSON like this, I’d like Grafana to color it in red, for example, when current is higher than 10% of the result of another query in the same panel.

[
   {
      "metricId":5191222,
      "metricName":"aaa",
      "metricPath":"aaa",
      "frequency":"CUSTOM",
      "metricValues":[
         {
            "startTimeInMillis":1704312420000,
            "occurrences":23,
            "current":2886,
            "min":0,
            "max":120545,
            "useRange":true,
            "count":858702,
            "sum":216513341,
            "value":252,
            "standardDeviation":0
         }
      ]
   }
]
10

is the other query also using infinity? My telepathic powers are at zero today so cant read your pc remotely :stuck_out_tongue_winking_eye:

11

Yes… All of the queries in this dashboard are using infinity. Thank you for your interest!
I’d also like to compare queries’ results from different panels, so that I can paint in red, for example, the worse.