I’m new to Grafana (using 6.7.2 windows build) and I’m currently struggling to coloring the background in Singlestat panel. I have already searched the community and have tried a couple of things but unfortunatley with no success. So please bear with me if this question is actually already answered.
I think the problem is the time format of my query output.
As you can see the unit is set to duration (hh:mm:ss) what matches exactly my query output. But why is the thresholds are ignored? What I want to achiev is a dynamic background with coloring like this
if (value <= 01:00:00)
else if (value > 01:00:00 AND value <= 02:00:00)
else if (value >= 03:00:00)
Any help is much appreciated.
You’re setting the thresholds based on the formatted value (hh:mm:ss) rather than the value in the query result.
If I assume that the query returns UNIX timestamps, the threshold should be something like:
IF (value <= 3600000) THEN GREEN
where 3600000ms = 1h
thanks for you quick answer. But no, this is indeed the query output. Here is the important part of the query what I’m using to calculate time averages out of a Maria DB datasource.
TIME_FORMAT(SEC_TO_TIME(avg(hour(Bearbeitungszeit) * 3600 + (minute(Bearbeitungszeit) * 60) + second(Bearbeitungszeit))),’%H:%i:%s’) Bearbeitungszeit
But maybe I don’t need the formatting in the query itself, probably I can just use a unix timestamp and the formatting will be done in the value unit. Probably with unix timestamp query output the threshold function can work better.
I will give it a try and will give feedback.
I have tried a couple of thins with unix timestamp query results and it seems grafana interpreted it not quite correctly.
I have now a unit timestamp with 1586988004 what can be convert in a correct date
When I change my query in Grafana I get the same output first but the coverting is strange when I set unit to a datetime value.
The unit duration comes more close to what I try to achieve, but why I dont’t get just hh:mm:ss as desired?
Could it be there is a difference as a unix timestamp is intepreted between my local maria db and grafana?
Anyway, no change a hh:mm:ss query output can used in singelstat thresholds?