Add decimal points

Grafana Dashboards
1

I’m using grafana v8.5.4 and influx2, I have a snmp setting so I getting integer temperature.

143 °C but should be 14.3 °C, I’m not sure how to add the decimal point in the last number.

image

any function that could be help?

this is the csv data.

“Time”,“temp.TempR1”
2022-06-07 13:46:00,152 °C
2022-06-07 13:47:00,152 °C
2022-06-07 13:48:00,152 °C
2022-06-07 13:49:00,153 °C
2022-06-07 13:50:00,153 °C
2022-06-07 13:51:00,152 °C
2022-06-07 13:52:00,153 °C
2022-06-07 13:53:00,152 °C
2022-06-07 13:54:00,152 °C
2022-06-07 13:55:00,152 °C
2022-06-07 13:56:00,153 °C
2022-06-07 13:57:00,152 °C
2022-06-07 13:58:00,152 °C

2

Best would be correct data in the csv, but that’s not the answer you want to hear. :smiley:

You can use a Transformation to devide your value by 10:

2022-06-08_21h34_32
2022-06-08_21h34_321166×721 105 KB

  1. Create a new “Add field from calculation” Transformation
  2. Select Binary Operation
  3. Choose the field that should be devided by 10
  4. Give it a new Alias if needed
  5. Activate switch and you only see the new calculated Value
3

Wow! good job.
that’s I wanted heard

image
image766×243 33.1 KB

1 Like