I have connected a PostgreSQL data source to my Grafana, but the LCD does not change according to the results of my query. I have also set thresholds, and the queried data is of numeric type.
Hi, have you tried setting Max and Min options? My guess is Grafana doesn’t really know what the percentages refer to when calculating those. Also, did you mean to set thresholds to percentages? It doesn’t matter if your unit is percent, if you e.g. want to set orange color if your data is 20% you should still use 0.2 (unless you wanted to dynamically calculate the threshold, then it should be left like that).
I understand what you mean. The value I found using SQL may not necessarily be 0-1, it could also be 2 or 3 or 4 or 5, but I need to display the percentage here. For me, 1 is 100%, and 2 is 200%. I have set 1 or 100 or 0.5 or 50 here, and it will not change with my settings
ohh!You’re right, I didn’t set a maximum or minimum limit, it defaults to auto
1 Like