InfluxDB Issue with climate

I created a custom climate sensor using MQTT (its mostly working):

climate:
  - platform: mqtt
initial: 58
name: "Wine Room Temp"
temperature_command_topic: "myhome/wine/setdesiredtemp"
temperature_state_topic: "ha/wine/DesiredTemp"
current_temperature_topic: "ha/wine/Room Temp"
modes:
swing_modes:
fan_modes:

However, I am trying to track the temperature and various states in InfluxDB. I have the following config:

influxdb:
  host: 127.0.0.1
  username: home-assistant
  password: hapass
  database: home_assistant
  include:
    domains:
      - climate
    entities:
      - binary_sensor.entrance_motion

It’s creating series that don’t seem to work, is the issue the special character?

°F,domain=climate,entity_id=wine_room_temp

Any tips?

I have plenty of series with °C so, I don’t think it is that. What isn’t working?

I don’t see any data:

> show measurements
name: measurements
name
----
binary_sensor.entrance_motion
binary_sensor.front_door
°F
> show series
key
---
binary_sensor.entrance_motion,domain=binary_sensor,entity_id=entrance_motion
binary_sensor.front_door,domain=binary_sensor,entity_id=front_door
°F,domain=climate,entity_id=fin_temps
°F,domain=climate,entity_id=wine_room_temp
°F,domain=sensor,entity_id=living_room_thermostat_temperature
> select * from °F,domain=climate,entity_id=wine_room_temp
ERR: error parsing query: found °, expected identifier at line 1, char 15
> select * from "°F,domain=climate,entity_id=wine_room_temp"
> 
> select * from "°F,domain=sensor,entity_id=living_room_thermostat_temperature"
> ^C
>

When I write a query like that, I don’t get any data either. Grafana interrogates the database for me, and it comes up with a query like

SELECT "value" FROM "°C" WHERE ("entity_id" = 'lounge_temperature') AND time >= now() - 2d

which does return some results

Thanks, so there was some data there. My issue now is that some fields (operations_mode_str) are stored in text as “Off” or “Cooling”. Is there anyway w/ Grafana to use that data to show something like when it was cooling or off on a timeline? Doesn’t seem to work for me.

Or is there perhaps a way to set a script or automation so that when the data is written to influx it translates it from Cooling to 1?

Everything I want in grafana I have as a number, so I can’t be much help I’m afraid.

The best thing I can think of is using another sensor as a number to track the thing you want, but duplicating data never sounds like a good idea.

Yea, I guess I could create a template sensor that translates the values? I’m still knew to this so I’m not sure what the best options are.