Grafana Rounding Numbers Stored as Strings

[pythoncoderas]

• What Grafana version and what operating system are you using?

v8.2.3 (fb85ed6912) on Ubuntu 20.04 LTS

• What are you trying to achieve?

I want to display table data and variables

• How are you trying to achieve it?

MySQL query

• What happened?

One of the columns has long numbers, and so they are stored as strings. Grafana is rounding these numbers to the nearest 10s place, and the variables are no longer working because of that.

• What did you expect to happen?

The numbers not to round

• 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.

No

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

No

[mattabrams]

Hello and welcome to the forum, @pythoncoderas

Have you tried using the convert field type transformation to explicitly set that column’s type:

Types and options

[barma666]

Hello. I have the same problem. This trick(convert field type) doesn’t work because the values ​​grafana gets from influxdb are already rounded. Any ideas that might be helpful are welcome.