Celsius conversion to Fahrenheit

1

I’m looking to convert Celsius to Fahrenheit in Grafana and not sure how the math or code is to do so, or where to put it?

Can anyone help out, can’t seem to find this simple thing online.

2

Multiply the value in your data store query by 1.8 and add 32.

If you’re not sure how to do that, paste your query here (please use text, not
a screenshot) and tell us which back-end data store you are using.

Antony.

3

Oops, sorry, just realised you asked this question on the InfluxDB list and not
the Grafana list (I’m on both), therefore it’s pretty obvious you’re using
InfluxDB as the back-end data store.

Apologies for asking for redundant information.

Antony.

4

All good. Here is the code:
SELECT mean(“temperature”) / 100 FROM “philips-hue” WHERE (“device” = ‘computer-room-temp’) AND timeFilter GROUP BY time(__interval) fill(null)

I’m still learning how to do all this, would you know how to also add it if I was looking at the other editor? The one that you can pick things, not the code?

5

SELECT mean(“temperature”) / 100 FROM “philips-hue” WHERE (“device” =
‘computer-room-temp’) AND $timeFilter GROUP BY time($__interval)
fill(null)

Okay, change that to:

SELECT mean(“temperature”) * 0.018 + 32 FROM “philips-hue” WHERE (“device” =
‘computer-room-temp’) AND $timeFilter GROUP BY time($__interval) fill(null)

I’m still learning how to do all this, would you know how to also add it if
I was looking at the other editor? The one that you can pick things, not
the code?

No, I don’t believe that’s possible.

The trick with Grafan is to use the “menu selection editor” or whatever you
want to call it, first, in order to get close to what you really need, and then
use the Query Editor where you can type anything you like, but have to know
what you’re doing, for the fine adjustments (such as above).

Then, very importantly DO NOT switch back to the menu-items editor, because
if you do, Grafana will gratuitously throw away all your changes and go back
to what it had to start with. I’ve said on the Grafana list that I regard
this as a bug more than just an annoying feature, but it’s important to be
aware of it otherwise you can lose valuable work, and possibly not even
realise to start with, that that’s what’s going on.

Antony.

6

Ah ok, appreciate the info. Not sure why, but the decimal wouldn’t work, I had to use * 9 / 5 + 32 for it to work.