Grafana Rounding Numbers Stored as Strings

  • 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

Hello :wave: and welcome to the forum, @pythoncoderas

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