Singlestat not displaying the "true" value

[flaris]

Hello all,

I’m trying to display a text metric which can have two possible values “true” or “false”, but when I configure it in a singlestat pannel, it returns NaN.
I have tested the same pannel with other text metrics without any problem.
Is there any workaround to fix that issue?

Thanks in advance,
Flaris Feller.

[daniellee]

You should be able to use value to text mappings to map it to whatever you want:

You could also double check the result of your query in the Chrome network tab to make sure that it is returning the values you expect:

How to troubleshoot metric query issues

If you get a panel query error or not seeing the data you expect to see the most important thing to do is view the query Grafana sends to your database and what the raw response is. This information is not built into Grafana yet but can be easily investigated using Browser Dev Tools. To open Chrome Dev Tools (F12, Ctrl+Shift+I on windows, Cmd+Opt+I on Mac), go the network tab. Hit refresh on the Grafana dashboard so Grafana sends a new data query. Try to find the query in the list of network c…

[flaris]

Hello @daniellee,

I’m going to trace the results using the procedure you send me.

Thanks in advance,
Flaris Feller.

[csf]

For me the value mapping didn’t work at first because I was using a TRUE/FALSE boolean, not the strings “TRUE” and “FALSE”. In Grafana I had to map the value of “1.0” and “0” for TRUE/FALSE.

However, I do get an annoying “toFixed() digits argument must be between 0 and 20” error in the top left corner.

[jvdp]

I’m having the same issue. Running v5.3.0. I saw that this was a bug that apparently got fixed in v2.1 but it seems to persist? Or am I doing something wrong?