-
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.
What is your data source?
I would do it with Overrides value mapping
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?
use jsonata or transformations to get the percentages.
I am not a fan of transformation, I like to do it on the data source itself.
Butā¦ how does this relate to thresholds? I meanā¦ how to utilize the calculated values as thresholds?
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
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.
the same principle applies. is it a calculated value or static value? Please provide sample json data coming from your api
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
}
]
}
]
is the other query also using infinity? My telepathic powers are at zero today so cant read your pc remotely 
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.
May be āConfig from query resultsā transformation would help in your case:
https://play.grafana.org/d/Fc6gwV4nz/transforms-config-from-query?orgId=1&viewPanel=6
Add additional field to your query that would contain required value color basing on calculated in the same query dynamic threshold.
1 Like
but be attentive with āconfig from query resultā.
The same value has always the same colour.
look at the āOKāā¦
